G
Guest
I have field defined as number/single. When performing simple DLookups an/or
simple calculations on them and then displaying the result in text boxes, it
is often displayed with extra digits. For example, an entry that was
calculated as 30 - 30.22 shows -1.7800007.
The text box itself has decimal places set to Auto (which is correct,
because it could vary) and no format, although General Number format produces
the same result. The result is also the same whether or not the format in the
table is blank or General Number.
How do I get numbers to display the correct data without the ghost decimal
places?
simple calculations on them and then displaying the result in text boxes, it
is often displayed with extra digits. For example, an entry that was
calculated as 30 - 30.22 shows -1.7800007.
The text box itself has decimal places set to Auto (which is correct,
because it could vary) and no format, although General Number format produces
the same result. The result is also the same whether or not the format in the
table is blank or General Number.
How do I get numbers to display the correct data without the ghost decimal
places?