Restrict a day

[Ivor Williams]

On a form, I have a text box in which I want to enter a date. I want to
restrict it so the date entered is a Sunday. How can I do this?

 

[MAHalim]

I think you mean Day or you mean date?
if you mean day you can try this...
Click on the text box property, then on the (Validation Rule) type Sunday,
then you can add any message for the users in the (Validation Text) Type
"Only Sunday is acceptable" or any other message to be displayed if different
value been entered.
Also in the (Default Value) room on the property you can add Sunday so you
don't need to type it every time.
Hope it will help

M.A.Halim

 

[Ivor Williams]

I want to enter a date, but only a date that falls on a Sunday. I tried
using the Long Date format (Sunday, April 8, 2007) and in the validation
rule tried Sunday*. It didn't work.

 

[Guest]

Try this in the valadation rule --
Format([YourFieldName],"w")=1