98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Input Masking
Input Masking
Resolved · Low Priority · Version 2003
Gillian has attended:
Access Introduction course
Input Masking
Just to refresh my memory, please can you give an example where Input Masking would be used and the advantage of it?
Thanks
Gill
RE: Input Masking
Hi Gillian, Thanks for the question, in reply, Input Masking is used to ensure that the data entered in a particular field is correctly entered ie if you only wish to allow Alphabetical entries in a field then Input Masking will not allow Numbers to be entered, or if you wish your entries to be in a particular style ie 123AA321 then setting up an Input mask will ensure that only this style of entry is permitted. Input Masking can be created manually or you can use the Input Mask wizard and create your mask from the options that are given;
I hope that helps, best regards Pete.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |