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