Entering fractions into a numberic field reflected on a form

F

Frank

I have a numeric field placed on an entry form. I want to be able to enter
fractions into the numeric field - eg. 2.33, 2.60, etc.

What is best way to do this.

Thanks tons for help.
 
D

Duane Hookom

It isn't clear what your issue is. Why can't you simply type 2.33 or 2.60
into the text box?
 
F

Frank

Thanks for reply. I just added to the form, a straight numeric field from
the "Field List." When I type in a number which has a decimal point - eg.
2.5, 3.5 ,etc. it returns 2.0,3.0, etc. Tried formating, etc without
success.

Comments?
 
D

Duane Hookom

That's certainly a better description. I expect your field data type is set
to Numeric - Long which only accepts and stores whole numbers. If you want
to store decimal portions, then you will need to change the data type to
Double, Single, Decimal, or Currency.
 
F

Frank

Thanks again for your timely and professinal assistance. When with the
double option and all is well is River City.
 
Top