access+course+training - Message related to input mask

The UK's most regular instructor-led training courses.
Training information: access+course+training · Access training · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Message related to input mask

by - trainer Amanda diamond contributer [1205 posts] (2007 Aug 7 Tue, 12:31) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Message related to input mask

by - trainer Richard platinum contributer [813 posts] (2007 Aug 13 Mon, 12:05) Reply

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

· Get More Out of MS Access Courses
· Access Database Optimization: First Normal Form
· Microsoft Access and Customer Surveys
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Microsoft Access, an Efficient Database Tool