Date field

[qpl]

Hello,
I have a date filed (mm/dd/yyyy) on the form, and I like to see user can not enter date on this field if the date is greater than today day.( it must be today day).
Or a popup warning dialog box to let them check for the date they enter wrong.
Thanks s lot.

 

[chewy]

do you always want it to be todays date?

 

[qpl]

The date field always today date, but the filed need blank untill they input.
Can you help.

 

[ShannonMarie]

Just a thought

I know that access has a feature that will enter todays date when you enter Today in a field. You may be able to enter <=Today() as a validation rule to enforce a date on or before todays date. The feature is listed in the access help file but not alot of information is offered as far as formats. I did not run the line but it is logical. Hope that works. You could also write a validation rule in the expression builder for that particular field to test what has been entered.

 

[chewy]

I dont understand why it has to be blank. If it is always going to be todays date why no just populate it when the record is created?

 

[qpl]

It worked, but still one problem that the user can input any provious day.
Do you know how to write VB code ?
Thanks for your help

 

[qpl]

Some records don't require date, but some do. That why I need it blank.
Thanks for your help

 

[qpl]

I think I got it. Thanks