Microsoft Access 2000 Combo Box

  • Thread starter Thread starter Joe Majkrzak
  • Start date Start date
J

Joe Majkrzak

I am setting up a dialog combo box with a list of values
that have 3-decimal places to use for selection. The
source for the combo box is a query. The query displays
the values with 3-decimal places, yet the combo box
displays only 2-decimal places. This creates a non-match
for my form. How do I get the combo box to display 3-
decimal places as shown in the query?
 
Joe,
Sorry about that.
Way past my bedtime here in Ireland.
The decimal places only comes into effect after data entry.
What you need to do is set the Format property of the field in the source
query to "0.000"
Again, apologies for misleading you and anyone else in the newsgroup.
John
 
Back
Top