Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access-training-courses - Input Mask

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access-training-courses - Input Mask

Resolved · Low Priority · Version Standard

Reply Wed 31 Oct 2007, 14:37Trainer Rajeev said...

Input Mask

Hi

I have just put input mask and I get the following:

(999)999-9999;1;"#"

I understand (999)999-9999 BUT What do the ;1 and ;"#" really mean? I DIDN'T PUT THEM THERE!!!

For upcoming training course dates see: Pricing & availability

Reply Wed 31 Oct 2007, 15:05Trainer Rajeev said...

RE: Input Mask

Hi Rajeev

Input mask is something that many people are not clear on sometimes even having attended the Access training. This is mainly due to all these strange symbols and characters that form a part of the input mask.

There are mainly three sections of an input mask and they are separated by ;

The first section before the first ; is which what defines the mask itself. so in your case if (999)999-9999 was for a telephone number then it will take that appearance.

The reason you chose 9 instead of a 0 is because in some telephone nos. there might not be an entry required.

But if you wanted an entry to be mandatory then you would have used 0 instead of the 9.

similarly if you wanted the user to enter and alphabet character then you would have used L (please remember that this will be mandatory for the user to enter). However if you want you can use ? to allow the user to enter alphabet characters but then the entry is not mandatory!

NOW COMING TO YOUR MAIN QUESTION:
the second section that appears after the second ; is there to tell Access if the literal characters (such as Brackets or parentheses and dashes). 0 will store the characters and 1 will only store the data without the dashes or brackets within your table.

Third section is telling Access what symbol would you like to display before the user starts entering the data. so in your case if it says "#" what the user will see in the data sheet view is (###)###-####

If you wanted the field to remain blank then simply enter ; "" in the third section.

I hope this has helped!!

Thank you

Kindest Regards

Rajeev Rawat

Access articles

· How To Import Data Easily Into Access 2010
· How To Use Multiple Parameters In A Microsoft Access Query
· How to Find a Third-Party Venue for Microsoft Access Training
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· How To Use Lookups For Data Entry In Microsoft Access

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips