Displaying 3 decimals in a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't get a combo box to display a 3 decimal format, even though I've set
it in the properties. It views as 3 decimals in the underlying query for the
combo box, but not in the box itself. I want the value .375 instead, it
rounds up to .38.

Any ideas?
 
You have to use the Format() function explicitly in the Query to convert the
numeric value to Text value. Create a calculated Field in your Query like:

Value3D: Format([NumericField], "#.000")

and use this calculated Field instead of your NumericField.
 
Back
Top