I'm creating a program and want to stop dates being entered one week before
the current date and two months after the current date

I'm not sure how you would control this with a calendar control, however, you
should be able to use the After Update event, of the field storing the data.

[txtDate1] Between (Date-7) and (Date + 60)

Sharkbyte


"Anthonydan206" wrote:

> I'm creating a program and want to stop dates being entered one week before
> the current date and two months after the current date

Sharkbyte <(E-Mail Removed)-> wrote:

>I'm not sure how you would control this with a calendar control, however, you
>should be able to use the After Update event, of the field storing the data.
>
>[txtDate1] Between (Date-7) and (Date + 60)

Trouble is 60 isn't exactly two months. I'd suggest using the
DateAdd function instead.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm