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

Input Masking

ResolvedVersion 2003

Thu 3 Apr 2008, 08:37 Delegate Gillian said...

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

Thu 3 Apr 2008, 09:29 Trainer Pete said...

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 courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

Input Masking

Input Masking

RE: Input Masking

Access articles

Access tip:

Open A Combo Box Automatically