input masking

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Input Masking

Input Masking

resolvedResolved · 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.


 

Access tip:

Remove spaces in a table

If 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

View all Access hints and tips


Server loaded in 0.1 secs.