Can't change number format on report

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

If I want to change the number format on a report the
format listbox is empty. I want it to display only two
decimals but even if I set the decimal place to 2, it
displays infinate decimal places. Am I doing something
wrong?
 
You must set the Format property in addition to the Decimal Place property.
Try set the Format to "Standard".
 
Problem is that in the property box the format listbox is
empty, so I can not set it to standard. I've typed it in
but this does not work?
 
What is the data type of the value bound to the text box? If you look at the
data sheet of the report's record source, is the column left or right
aligned? If it is left aligned, this suggests the column/field is being
treated as a text/string value. You would need to change your control source
from:
[MyField]
to
=Val([MyField])
Make sure the Name of the text box is not the same as the name of the field.
 
Back
Top