Newbie needs help with Validation rule.

[pip]

I have a question about setting a validation rule .I am new to this and I have been given a task to do and I can't work it out.
I have to do a default date of todays date. which I have done. But I dont know how to do the validation rule so no future dates can be keyed in. Or how to create a suitable Validation text.



Could someone help me. Thanking you in advance. Pip

[CJ_London]

a validation rule is written much like any other formula

e.g.

<=date()

means the user can only enter a value less than or equal to today

then you would add some meaningful text to the validation text as a message e.g.

'Cannot be later than today'

- note, quotation marks not required

[orange]

pip,
In addition to ajax's answer -- don't underestimate the value of Google/Bing

Here is a Google identified link for search term "msaccess validation rule"

Good luck with your project.

[pip]

a validation rule is written much like any other formula

e.g.

<=date()

means the user can only enter a value less than or equal to today

then you would add some meaningful text to the validation text as a message e.g.

'Cannot be later than today'

- note, quotation marks not required

THankyou very much appreciate your reply

[pip]

Thankyou for the link. Appreciate it. Pip