Combo box will not display 3 decimal number in drop down list.

[mgalvinjr]

I have a table, ComponentFixed:


> Field name: ID. Date Type: number. Field size: double. Format: Fixed. Decimal Places: 3
> Field name: Component. Data Type: short text.


Rows:
ID   Component
1.001  Roof
1.002  Flat Roof
2.001  Road
99.999  Building


I created a blank form. In design mode, I dragged a new combo box ontoit and used the combo box wizard. I chose my only table (above), I choseboth fields from the table (ID, Component), then the wizard displayed thecontents of both fields to allow me to adjust the column widths. At thispoint I noticed that the ID displayed the above numbers as follows: 1.001, 1.00, 2.00, 100.00. This is not the 3 decimal display Iexpected.


When I opened the form and dropped down the combo box list, the ID numberswere displayed as: 1.00, 1.00, 2.00, 100.00.


How do I get the combo box to display the numbers with 3 decimals as used inthe underlying table?


Note: I did the same as above without using the Wizard and got thesame results.

[June7]

I change field properties to no Format and Auto DecimalPlaces and then numbers displayed properly.

[Minty]

I would also not use a double as an ID field, use a decimal data type.
You can get rounding errors with doubles, meaning if you used it in a join you could get odd results.

[Welshgasman]

I would have a standard autonumber ID and your ID field with a name that is meant to indicate what it actually is.