How do i get decimal places out of a form control combo?

sportsguy

Finance wiz, Access hack
Local time
Today, 04:00
Joined
Dec 28, 2004
Messages
363
The field format is set to Currency, Standard , 0 decimal places,
the combo is set to Currency, Standard, 0 decimal places,
the tables are set to Currency, Standard, 0 decimal places,

the combo list drop down shows 2 decimal places, how do i get rid of the decimals?

thanks

sportsguy:confused:
 
Instead of setting it there, just set it in the FIELD for the query:

ANewName:FormatCurrency([YourFieldNameHere],2)
 

Users who are viewing this thread

Back
Top Bottom