Restricting a date that is input

[Stuart Green]

I have a table where the user enters a date. I only want them to be able to enter a Friday date. I am trying to get some sort of table validation to do this but can't get the syntax right. Is it possible please?

 

[Rich]

Only at form level, look up vbFriday

 

[pdx_man]

Try this in the Validation Rule property line for the field MyDate in your table:

Weekday([MyDate],1)=6

Then in the Validation Text, add whatever message you want the user to receive when they don't enter a date that is a Friday.

Check out the Weekday function in Access Help.

 

[Stuart Green]

The weekday worked a treat, thank you very much. I seem to spend more time trying to get the syntax for validation to work at form level than I do for any other part but this worked first time

 

[pdx_man]

And you DID put this at table level, right?