Form won't show decimal input

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

 

[Rick Brandt]

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!

What is the Field Size setting of your field? I'm guessing Integer or Long
Integer neither of which support decimals.

 

[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

 

[Guest]

That was it! Like I said, I went brain dead. Thanks for the jolt back to
reality.