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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
access+course+training - message related input mask

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course+training - Message related to input mask

access+course+training - Message related to input mask

ResolvedVersion Standard

Message related to input mask

Hi

Can you set a message to appear to help a user to enter data in the correct format when an input mask is set? The warning that comes up by default is not very user-friendly.

cheers
Amanda

RE: Message related to input mask

Amanda,

You can use DATA VALIDATION in conjunction with an INPUT MASK to create a custom message for the user.
Input masks simply limit the data entry to a specific format, wheras data validation will evaluate and promt for a new answer.

Used together you can restrict almost any incomming data to the format you like. Great for keeping data integrity (ie: all data is correct, not corrupt).

Regards

Richard

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.