I've designed a DB that makes printouts of work permits. Most of the time the
user only requires a printout of a permit for the current day. However, they
occasionally require a permit printout for several days/weeks ahead. On the
GUI it needs to show both the date (dd/mm/yyyy) and what day of the week it
is. I've put a Calendar control on the GUI and when I click on a date in it,
it puts that date in the caption property of a label control but I can't seem
to find a way of putting the day of the week into the caption property of a
label control. I wrote this bit of code
Me.lblWeekday.Caption=Me.Calendar6(Day) and noticed that the word "Day"
equalled the day of the month numerically. Is there a way of converting this
into the actual day of the week? like Wednesday for example.