Apologies in advance. I'm new to access and have been asked to re-work an existing form of a larger application. My background is more with Paradox than access.
Problem: One field is intended to only receive numeric data. The field tho' is defined as text. Because there are a number of reports and possibly other dependencies, I'm reluctant to immediatly do the obvious: convert the 'text' field to a number field. (it has some legacy text entries already)
Going forward I'd like have an input mask on the form that restricts input to numbers, with some sample acceptible field values of:
=========
1
1.1
1.12
12
12.12
...
99999
99999.99
=========
I can see how to fairly easily restrict the input mask to numbers only e.g:
99999
But my efforts so far to allow decimals have failed.
99999;9999.99
or
99999;9999\.99
Any suggestions with more information/examples of input masks would be appreciated.
Thanks,
John
Problem: One field is intended to only receive numeric data. The field tho' is defined as text. Because there are a number of reports and possibly other dependencies, I'm reluctant to immediatly do the obvious: convert the 'text' field to a number field. (it has some legacy text entries already)
Going forward I'd like have an input mask on the form that restricts input to numbers, with some sample acceptible field values of:
=========
1
1.1
1.12
12
12.12
...
99999
99999.99
=========
I can see how to fairly easily restrict the input mask to numbers only e.g:
99999
But my efforts so far to allow decimals have failed.
99999;9999.99
or
99999;9999\.99
Any suggestions with more information/examples of input masks would be appreciated.
Thanks,
John