enter a date onto an Access Form to not accept Wednesdays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Office XP.
I want to enter a date onto a form that will accept it only if it is not a
Wednesday.

I can enter the error message "Not a Wednesday", but I can't find the right
syntax for a formula which refuses Wednesday as a day of the week.
 
rogerc said:
Office XP.
I want to enter a date onto a form that will accept it only if it is
not a Wednesday.

I can enter the error message "Not a Wednesday", but I can't find the
right syntax for a formula which refuses Wednesday as a day of the
week.
Click to expand...

Validation Rule of...

Weekday([FieldName]) <> 4
 
Back
Top