Can't stop Combo Box from rounding

[aliendan]

No matter what I do! Everywhere, the table, the query, the form, the combo box...everywhere it is formated to Single; Fixed; 3 decimal places. But when I use a combo box to query the table to populate another field the combo box is rounding my values from 3 decimal places to 2. I even went into the Regional Settings and changed the number decimal places to 3. Nothing can stop this anomaly. Anyone have a solution?
Dan Rogotzke
Dan_Rogotzke@oxy.com

 

[JoeMiller]

Resize the column in the combo, make it larger. Access tries to help you by rounding some numbers that won't fit in a control, column, etc...

Joe Miller
joe.miller@flotech.net

 

[aliendan]

That's not it. I set to 4" and it didn't change a thing. Any other ideas? This is pretty wierd.
Dan Rogotzke
Dan_Rogotzke@oxy.com

 

[JoeMiller]

You can force the format of the number in your select statement for the combo box by using the format function.

format([MyNumber],"#,###.000&quot

That would always give you a three digit decimal. Joe Miller
joe.miller@flotech.net

 

[aliendan]

My gosh, why didn't I think of that. Thank you. I forget more than I remember. Hehaha.
Dan Rogotzke
Dan_Rogotzke@oxy.com