Validation Message Box

[Irfan Salim]

In my access database, there is a table Employee. One of the field is DataOfBirth. The validation rule property of this field is <Date() and validation text is, Birth Date can't be in the future. In my access form, if a user enters date greater than current date, then a message box is displayed with the validation text and two button, OK and Help.

What I want is to show only OK button and not the Help button.

 

[wizcow]

Irfan

In your code you will have line that looks something like this;

Msgbox("Birth Date can't be in the future",vbOKHelp,"Error")

The Message Box format is ("message",buttons to add, form "header")

After the first comma there may be a number instead of vbOKHelp.

Change vbOKHelp or the number to

vbOK

That should get rid of your help button.

Tom