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