Entering fractions into a numberic field reflected on a form

  • Thread starter Thread starter Frank
  • Start date Start date
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.
 
It isn't clear what your issue is. Why can't you simply type 2.33 or 2.60
into the text box?
 
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?
 
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.
 
Thanks again for your timely and professinal assistance. When with the
double option and all is well is River City.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top