Form won't show decimal input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created an input form that places values into a table. My form rounds
off any decimal input to a whole number. How do I maintain the decimal input?

I've done the following:
My table field is formatted to General number with a decimal place of 2
My form field property matches my table field.

Thank in advance for your help. I know this is a simple issue, but I must be
brain dead!
 
dab1477 said:
I've created an input form that places values into a table. My form
rounds off any decimal input to a whole number. How do I maintain the
decimal input?

I've done the following:
My table field is formatted to General number with a decimal place of
2
My form field property matches my table field.

Thank in advance for your help. I know this is a simple issue, but I
must be brain dead!
Click to expand...

What is the Field Size setting of your field? I'm guessing Integer or Long
Integer neither of which support decimals.
 
Dab,
You probably have designated this field's DataType as a Byte, Integer, or
Long Integer in your table design. Those are "whole number" Types, and
don't allow for decimals... regardless of what your Format is.
Try Single or Double...
hth
Al Camp
 
Back
Top