Combo Box Format

[JWeaver]

I have a combo box that pulls employee number, employee name, and pay rate
from the Employees table, however, instead of formatting the pay rate as it
is in the table (number, double, currency, 2 decimal places), it drops any
trailing zeroes. Example, instead of 8.50, it displays in combo box and in
the text box I have it copied to as 8.5; instead of 14.00, it displays as 14.

Your help would be much appreciated!

 

[Jeff Boyce]

A combobox on a form displays the data in its record source. If you are
using a query to 'feed' that combobox, look to the query to coerce the data
into currency format (or use Format() or the format property).

Take a look at the CCurr() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[AJOLSON]

I would try setting my text box properties to Currency and change auto to 2
decimal places. Also set properties in the combo box to the same. That
might work. Although as you view them in the combo box it will be truncated.
Or appear out of wack. Hope that helps I am sure there is a code that
would solve the problem too. Not sure what it is though