decimal Places

D

DaveB

I have a field called BillableHours. When I type in 1.5
it automatimally changes it to 1. I have the format set
to General Number and the Decimal Places set to Auto. Is
there something else that I'm overlooking that makes it
automatically change like that? I tried Standard and
Fixed but that just changed my 1.5 to 2. What can I do so
that it will accept the 1.5?
 
C

Cheryl Fischer

Check the FieldSize property of BillableHours. It is probably set to Long
Integer or Integer. If you'll change it to Double or Single, you will be
able to enter decimals.

hth,
 
F

fredg

DaveB said:
I have a field called BillableHours. When I type in 1.5
it automatimally changes it to 1. I have the format set
to General Number and the Decimal Places set to Auto. Is
there something else that I'm overlooking that makes it
automatically change like that? I tried Standard and
Fixed but that just changed my 1.5 to 2. What can I do so
that it will accept the 1.5?

You can change the field's Field Size property from Integer (or Long
Integer) to Double or Single.

By definition, an Integer can only be a whole number.
No decimals allowed.
 

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

Top