I have a combobox on a form that is populated by running a query of a table. I would like the decimal formatting for all to be 3 decimal places. The issue is, when I select the drop down list from cmbHXRShellOD on the form, the decimal places are rounded up to 2 decimal places. The formatting for the combobox, table column, and query is 3 decimal places. For example, I have a shell OD of 8.625. When this is populated into the combobox dropdown, it is listed as 8.63. Then when selected from dropdown, the combobox value is 8.630. How do I get the dropdown list to show 8.625?
form: Heat Exchanger
cmbHXRShellOD: Format-Fixed, Decimal Places-3, Column Count-1, Column Widths-1"