Forum Discussion
Formatting a Numbr in Forms and Reports
I've been trying to find something on this, but I'm continually running into dead ends. On a form or report, I'd like to format a number so that it shows correctly. The field is bound to a ta...
You can almost acheive this by using the Code #,###.## to the format field of the fields Properties box.
The result will show the Decimal point but no trailing digits if none exist and 1 or 2 digits if they do exist.
To fully remove the decimal point you would likely need to process it via a VBA function prior to saving, then display the saved data only.
The result will show the Decimal point but no trailing digits if none exist and 1 or 2 digits if they do exist.
To fully remove the decimal point you would likely need to process it via a VBA function prior to saving, then display the saved data only.