answersLogoWhite

0


Best Answer

To have your own message displayed when a user tries to enter data that does not meet your validation requirements in a field in Microsoft Access open the table in design view. Immediately below Validation Rule you will see 'Validation Text'. Click next to that and type in the message that you want to be displayed.

If you had made the Validation Rule >=25 you could type the following as validation text and it would appear in the message box that would appear if a figure lower than 25 was entered.

The rate per hour cannot be less than €25. Please enter a figure greater than 25.

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you change the error message for required validation rule on Microsoft access 2000 I have set 'required' to yes but I can't see a way to change the error message tht appears?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you get rid of the validation message in Microsoft office?

Connect to the Internet and follow the directions to validate your software purchase.


What is the message that will appear if a user violates a validation rule?

validation text


What is a validation rule?

In a database it is important that data is put in accurately. One method of doing that is to use validation rules to restrict what people can put in. So you might have a school where children have to be over a certain age before they can join. You could build a validation rule to ensure they meet that requirement or to ensure that the person entering the data does not make a mistake when entering it. A validation rule will stop them making an error and with the Validation Text, it will give them a message telling them what their error is.


What does the red message flag in microsoft Outlook mean?

Urgent message


What data validation rule is cautionary?

Data validation is all about what can be entered into a spreadsheet cell or database cell, you can choose an error message aswell as restricting what values can be entered, reducing human error and improving accuracy.


What does the Microsoft error message number kb890830 mean?

The Microsoft error message number kb890830 means a problem with a malicious file. In other words, one should delete that file (that caused the message) immediately.


How do you stop your computer from displaying this message - 'This copy of Windows did not pass Windows validation'?

Buy a licenced copy of Windows and install it.


How to remove the malware win 32it blocks my connectivity then an error message appears which on not sending w.explorer restarts.on restarting PC everything is fine for one time next restart is same?

Are avast, mcafee, norton,microsoft, sleeping???


Your Control Panel disappeared and you get the message 'This operation was cancelled due to restriction effected on this computer' even when you log in as an administrator?

Trojan.killVAIt might be the following: Trojan.killVA has struck my PC causing the same effect. 'Control Panel' from the Start Tab is missing and a message box to contact my administrator also appears, is this a virus message?. I have scanned and removed many times with 'Norton' but another message appears telling me to down load anti-spy ware. I have just downloaded and run the Microsoft Windows XP spyware from their site and it tells me that the PC is clean. Anyone help? Trojan.killVAIt might be the following: Trojan.killVA has struck my PC causing the same effect. 'Control Panel' from the Start Tab is missing and a message box to contact my administrator also appears, is this a virus message?. I have scanned and removed many times with 'Norton' but another message appears telling me to down load anti-spy ware. I have just downloaded and run the Microsoft Windows XP spyware from their site and it tells me that the PC is clean. Anyone help? * I suggest you format your pc**I suggest you reinstall or have it taken to a geek squad in your area or something


What is error 633?

This is error display system , when you modem is not install or configure properly


How do you use validation on Excel?

Validation allows you to limit what goes into cells. By applying validation you can do things like put an lower and upper limit on numbers entered into a cell, like allow only values between 1 to 100. You can also use it to highlight cells that already have values that are not valid, by applying validation and getting Excel to draw red ovals around the ones that are invalid. This can help you find errors in values that have already been entered. Validation allows you prompt the user to tell them what can be entered and also give them a message to tell them what they have done wrong.


What does deck message mean on Chrysler sebring convertible?

On most if not all sebrings it means that the trunk is open. If your trunk appears to be closed and the message still appears where the odometer reading is, check for an obstruction in the lock mechanism.