Calendar Control

[Guest]

Can I use the Calendar Control to select the day of the week and put it on my
Access form based on the date that a user selects from the calendar? I can
get it to put the actual date in a field on my form, but not the day of the
week. Thank you.

 

[Rick B]

You can use the format command to show the day of the week for a particular
date.

 

[Ed Robichaud]

I'd suggest using the calendar control (or better yet, use Steve Lebans
calendar http://www.lebans.com/monthcalendar.htm) to help your users enter
dates, then in
an unbound textbox, display the related day of the week. Set the control
source
of that textbox to: "=DatePart("w",MyDateControl)
-Ed