decimal Places

  • Thread starter Thread starter DaveB
  • Start date Start date
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?
 
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,
 
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?
Click to expand...

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.
 
Back
Top