Forum Discussion

malcolm_p_galvin_jr's avatar
malcolm_p_galvin_jr
Copper Contributor
Apr 12, 2023

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

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   Compone...
access
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Apr 12, 2023

malcolm_p_galvin_jr 


Double is probably not a good choice for the datatype of this field. It is often inaccurate.

 

For your purposes, with a requirement for 3 decimal places, currency would be a better choice for the datatype.

Resources