Changing field properties on form

  • Thread starter Thread starter Jk
  • Start date Start date
J

Jk

Hello,

I have a current problem in a field that is for dollar
amounts.The problem is that the amount when keyed is is
47.50..it defaults to a round number.I had changed the
field to currency on the form and then the error messages
begin.In table design, it is set at long integer, standard
and decimal places auto.Could you suggest if it is a
design problem or something in form properties?I also
tried in form properties to set the decimal place at two
but a meltdown followed after that....Please
advise...Thanks
 
Hello,

I have a current problem in a field that is for dollar
amounts.The problem is that the amount when keyed is is
47.50..it defaults to a round number.I had changed the
field to currency on the form and then the error messages
begin.In table design, it is set at long integer, standard
and decimal places auto.Could you suggest if it is a
design problem or something in form properties?I also
tried in form properties to set the decimal place at two
but a meltdown followed after that....Please
advise...Thanks

In table design, it is set at long integer, <
Click to expand...
The Table field size is a Long Integer. Long Integers and Integers, by
definition, are whole numbers. They cannot have a decimal value.

In the Table, either change the Field DataType to Currency, or leave
the Datatype as Number but change the Field Size to Single or Double.
 
A Long Integer is still an integer meaning it must be a whole number with no
fractions/decimals. Change the data type in the table to Currency in your
table and things should clear up.
 
Back
Top