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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display 3 decimals in combo box 1
Display fixed decimal place in Access forms 3
combo box display format 7
Decimal places in combo box 8
Combo box Number display Wrong 3
Combo Box Format 2
Format issue ... 2 decimal places displayed? 19
Access stripping decimal places in query 1

Back
Top