Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course+training - Message related to input mask
Resolved · Low Priority · Version Standard
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
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:Hiding rows and columnsTo hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column |
TrustScore
4.8
/ 5
2239 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
