Option for Two Decimal

[Guest]

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.

 

[Guest]

Datatype to integer-double in table design

Maurice

 

[John W. Vinson]

Datatype to integer-double in table design

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]

 

[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.

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]

 

[Guest]

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