Rounding question

[Guest]

There is a field on my form that allows a user to enter a number. When a
user enters ".75" it stays as .75. If the user were to enter "-.75" it
rounds to ".80"

The field's format is decimal places=Auto.

What would cause the rounding to this field when a negative number is entered?

tia,

 

[Guest]

I would first look at the database structure and make sure that I was using
double as a numeric formatat. I use abs(me.filed) to produce an absolute
value in an accounting database. The Debit and Credit key are what change.
You could check you input mask if you have one. Do you have error handling in
an after update macro.

 

[Guest]

Thanks for the reply. I should note that the SQL server on which the data
resides, the field type is float. Within the table itself, the -.75 is
stored as -.75. There's nothing wrong with the way a value is stored, just
how it's displayed.

tiaa,