Skip to Main Content
Microsoft® Office Access 2003 Step by Step
book

Microsoft® Office Access 2003 Step by Step

by Online Training Solutions Inc.
August 2003
Beginner content levelBeginner
368 pages
10h 49m
English
Microsoft Press
Content preview from Microsoft® Office Access 2003 Step by Step

Using Input Masks to Restrict Data

Using Input Masks to Restrict Data

When you use masks in tables or forms, people entering information can see at a glance the format in which they should make entries and how long they should be. You can use the InputMask property to control how data is entered in text, number, date/time, and currency fields. This property has three sections, separated by semicolons, like the mask for a telephone number, shown here:

!\(000") "000\-0000;1;#

The first section contains characters that are used as placeholders for the information to be typed, as well as characters such as parentheses and hyphens. Together, all these characters control the appearance of ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Access 2003 Inside Out

Microsoft® Office Access 2003 Inside Out

John L. Viescas

Publisher Resources

ISBN: 0735615179Supplemental ContentCatalog PageErrata