Regarding Forms

[Kundan]

1)I want only integers to be entered into the TextBox. How should be the Input Mask & what should be the validation rule?
2)I want a number with only 2 decimal places (eg. 12345.68) to be entered into the TextBox. How should be the Input Mask & what should be the validation rule?

[ranman256]

the Field Type is integer, you wont need a validation rule, it will only hold integers.

same with 2 decimal, when the field is set to Single (or Double), 2 decimals , tho you may need to truncate.
currency holds only 4 decimals.

[Kundan]

the Field Type is integer, you wont need a validation rule, it will only hold integers.

same with 2 decimal, when the field is set to Single (or Double), 2 decimals , tho you may need to truncate.
currency holds only 4 decimals.

Thanks a Lot! GOD BLESS YOU!!!

[isladogs]

Just to add
1. Integer has a limit of 32767. If you need more than that, use Long Integer instead
2. Similarly Double allows far bigger numbers than Single.
In both cases I recommend using Fixed format so e.g. 123.5 would be shown as 123.50 if using 2d.p.
For more info, see https://ss64.com/access/syntax-datatypes.html

[Kundan]

Just to add
1. Integer has a limit of 32767. If you need more than that, use Long Integer instead
2. Similarly Double allows far bigger numbers than Single.
In both cases I recommend using Fixed format so e.g. 123.5 would be shown as 123.50 if using 2d.p.
For more info, see https://ss64.com/access/syntax-datatypes.html

Thanks! Thanks!! GOD BLESS YOU!!!