Rounding my Currency up???

Randomblink

The Irreverent Reverend
Local time
Today, 12:30
Joined
Jul 23, 2001
Messages
279
I have a table with a Number/Currency field in it. I have a form that users input a monetary amount into it.

My problem is, as I input data into this field it is rounding up. I entered 5395.5 for the first entry, and the stupid thing rounded it to $5396.00?

Here are a few setting that I think might be relevant:

AllowAutoCorrect: NO
Format: Currency
DecimalPlaces: Auto

Help me Obi One Kenobi, Your our only hope!
 
Is the field's Data Type defined as a 'Number' or as 'Currency' in your table? If it's 'Number' is the Field Size some type of integer?

~Abby
 
That was the problem...
I went in at the table level and changed it to Currency...that solved the whole stinking problem...
Muchas Gracias
 

Users who are viewing this thread

Back
Top Bottom