Form won't show decimal input

D

dab1477

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!
 
R

Rick Brandt

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.
 
A

AlCamp

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
 
Top