Problem seeing 0,100 in a text box, dropdown or list

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have been beating my head against the wall for days.
I am in Europe and have got to display a value as 0,100.
I have tried all the standard, fixed and all the rest.
I thought the problem was in the format of the list and now I have made the
input box just text and still have the same problem.

I have the decimal set to 3
I have tried all the types of numbers and the problem persist.
the text box shows 0,000 with a comma when blank
when I enter 0,100 on the keyboard, it types in but when I hit enter the
input box goes back to 0,000

I have the computer set to the local settings for Italy.



thanks for any insight
Michael
 
Try defining this as Currency. And if this control is bound to a table
field, then that field in the table's definition. should also be Currency.
 
thanks bob, but that only gives me a currency symbol in front of 0,000
Michael
Click to expand...

You're field's datatype is probably Integer or Long Integer.
By definition, an Integer is a whole number and cannot have a decimal
value.
Set the Field's DATATYPE to currency, (not just it's Format -- they
are different), or use Double Datatype. Then set the decimal property
to Fixed, 3 decimals.
 
Is this a bound form?
Is your textbox the last item in the tab order?
If both are true, you may simply be moving to the next record.
Try setting the form's Cycle property to "current record".
 
Thank you fred,
that did it.
michael

fredg said:
You're field's datatype is probably Integer or Long Integer.
By definition, an Integer is a whole number and cannot have a decimal
value.
Set the Field's DATATYPE to currency, (not just it's Format -- they
are different), or use Double Datatype. Then set the decimal property
to Fixed, 3 decimals.
Click to expand...
 
Back
Top