Date field

[Beginner Bill]

When I create a form with a date field how do I get it to open to the current month so the user can select the appropriate date ?

 

[Dirk Goldgar]

When I create a form with a date field how do I get it to open to the
current month so the user can select the appropriate date ?

How do you get what to open to the current month?

 

[Beginner Bill]

Sorry, what I want is to create a form with the date, and
when I open the form to add a record and click on the
date I would like the current month to show and be able
to highlight the day of the month and have it populate
the date field.
Thanks

 

[Dirk Goldgar]

Sorry, what I want is to create a form with the date, and
when I open the form to add a record and click on the
date I would like the current month to show and be able
to highlight the day of the month and have it populate
the date field.
Thanks

It sounds like you want one of a variety of date-picker controls that
are out there. Access ships with a Calendar control, or it used to;
but I haven't used it and I hear there may be some problems with
versioning and distribution. On the other hand, there have been several
messages posted in these newsgroups recently speaking favorably of
Stephen Lebans' Month Calendar, which is not subject to the problems I
mentioned. Follow this link for that:

http://www.lebans.com/monthcalendar.htm

There are others available, too, some implemented entirely as Access
forms. You may want to google for "Access Month Calendar" and to check
on The Access Web (www.mvps.org/access/) and some of the sites it links
to.