Displaying 3 decimals in a combo box

[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?

 

[Van T. Dinh]

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.