Formatting Decimals in a Combo Box or List Box

  • Thread starter Thread starter David
  • Start date Start date
D

David

I am having trouble with a couple of things. On separate
forms, even different databases I have either a control
that is a combo box or a field in a list box that I cannot
keep from putting two decimal places on. In the tables,
these fields are formatted as Double, Standard, 0 decimal
places. When I set up the value list or combox box and
format the query, I format it as Standard, ) decimal
places. When I open the query, it is formatted correctly,
but when the control displays, as a combo box or in the
value list it shows up with 2 decimals. Any ideas?

Thanks in advance for your help.
 
Dave,
How many decimal places do you want?
Change your query field to an expression:
[NumberField] = 123.32
For 1 decimal
Newfield:Format([NumberField],"#.0")
125.3

For no decimals
Newfield:Format([NumberField],"#")
125

Use this field in the combo box instead of the [NumberField].
 
Back
Top