Option for Two Decimal

L

Lamar

Is there a simple setting that will allow a user to only enter two digits
after the decimal in a text box. It should allow them to enter as many
digits before the decimals. Thanks for any help.
 
J

John W. Vinson

Datatype to integer-double in table design
Click to expand...

Ummm... There is no such datatype, Maurice. Did you mean Double? If so that
doesn't restrict it to two decimal places - more like fourteen.

John W. Vinson [MVP]
 
J

John W. Vinson

Is there a simple setting that will allow a user to only enter two digits
after the decimal in a text box. It should allow them to enter as many
digits before the decimals. Thanks for any help.
Click to expand...

You can use an Input Mask

"999999999999999.00"

using a Currency datatype (not any sort of Number); or you can (with A2002 or
later) use a Decimal datatype and specify the size of that decimal.

John W. Vinson [MVP]
 
M

Maurice

Hi John,

Yes I meant Double and you're right it doesn't restrict to two decimals.
Should have read more carefully to see that Lamar needed a restriction to two
decimals. Thank you for pointing it out to me..

Maurice
 
Top