Numeric Entry

[Earl G via AccessMonster.com]

I have tried. But now I ask. I cannot get a control to accept a numeric
entry (e.g. 0.23) without first entering a zero. I want to allow only two
decimal places. But I would like numbers less than 1 to be enter by pressing
the decimal then one or two digits. This is a normal entry method in Excel
and Foxpro, etc.. Any help would be appreciated.

Thanks in advance.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200704/1

[Ed Robichaud]

Is your field number type "decimal"? That allows entering just ".25",
though it displays as "0.25"

-Ed

"Earl G via AccessMonster.com" <u10839@uwewrote in message
news:71243060ac260@uwe...

>I have tried. But now I ask. I cannot get a control to accept a numeric
entry (e.g. 0.23) without first entering a zero. I want to allow only two
decimal places. But I would like numbers less than 1 to be enter by
pressing
the decimal then one or two digits. This is a normal entry method in
Excel
and Foxpro, etc.. Any help would be appreciated.

Thanks in advance.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200704/1

[egarber via AccessMonster.com]

Thank you Ed and Larry.
I am using an unbound text box. The numbers entered represent a dollar
amount anywhere from .01 to 100000.00. The Format property is for display
only as is the Decimal Places property. If I don't use an input mask, the
user can accidentally enter .011 which displays as .01 but uses .011 in all
calculations. When I do use an input mask, e.g.(#####.99;;" ") the user MUST
enter a 0.01 and cannot enter .01 without entering the 0 first.

I hope this helps explain the issue.

Thanks

Earl

Ed Robichaud wrote:

>Is your field number type "decimal"? That allows entering just ".25",
though it displays as "0.25"

-Ed

>>I have tried. But now I ask. I cannot get a control to accept a numeric
entry (e.g. 0.23) without first entering a zero. I want to allow only two

[quoted text clipped - 5 lines]

>>
Thanks in advance.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200704/1