Start Date must be a saturday

[iainmid]

Hi

I have a start date on a form. The fields data type is short date I need to create a validation rule so that when a user enters a date it can only be a saturday date which is entered.

Thanks for your help

 

[rainman89]

why not give them a list with the dates that are saturdays, that way they dont have the option to enter anything but a saturday!

 

[iainmid]

Hi Ray

creating a list is probably not the best way to do it because the start date is for a booking and user could creating a booking a few years in advance to have a list of every single saturday up to 2 years in advance seems a bit extreme. Is there no way of just validation the date being a saturday

Cheers

 

[rainman89]

In the after update of your txt box try

Dim isSaturday As String

Me.isSaturday.value = Format$(StartDate, "dddd")
If (Me.isSaturday.value<>"Saturday") Then
MsgBox "The date u entered is not a saturday please change"
StartDate.setFocus
Else
End if

 

[rainman89]

sorry that was the wrong one. delete that one and try this one

 

[iainmid]

Got it working
Cheers for your help