Display 3 decimals in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box with 2 columns. The first is a text column, the second is currency. The combo box fills from a table with the same field structure. In the table, the currency field holds a 3 decimal value. In the combo box the currency field displays only as 2 decimals. I need it to display in 3. Any ideas

Thanks
Mary
 
I am guessing here that this may be due to the computer's
Regional Settings. In the RowSource SQL, try using the
format function specifying 3 decimal places e.g.
SELECT textColumn, Format(currencyColumn, "#,##0.000") FROM etc

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
I have a combo box with 2 columns. The first is a text
Click to expand...
column, the second is currency. The combo box fills from a
table with the same field structure. In the table, the
currency field holds a 3 decimal value. In the combo box
the currency field displays only as 2 decimals. I need it
to display in 3. Any ideas?
 
Back
Top