Limit data entry date to exclude Sunday

[MICHELE]

I have a data entry form that users enter a Load date. I want them to be limited to only entering Load dates from Monday to Saturday (no Sunday Dates).

 

[Jack Cowley]

In the Before Update event of your LoadDate field use code like this:

If Format(Me![LoadDate], "ddd") = "Sun" Then
MsgBox "This is a Sunday"
Me.Undo
Cancel = True
End If