Active X Calendar Control

[Darrell Wootton]

Hi,

I currently use the calendar control (mscal.calendar.7) with a database to choose dates.

I use the calendar to automatically insert a date into a date field on the form.
This works fine.

However, is it possible to use the calendar to insert data into more than one field at a time and amend the format?

ie:

Currently I use 1 field to insert dd/mm/yyyy

Is is possible to insert data into two fields from the calendar ie:

field 1: dddd (ie:Thursday)
field 2: dd/mm/yyyy (ie: 02/04/04)

Thanks in advance

Darrell....

 

[Grahamo]

Not sure if you can get the calendar to do that but I'm new to VBA, I'd try this to see if you could get the result that you need.

create a text box called "Day" for example on your form and set it's control sourse as the text box that has the calendar as its control source. then set the format for the "Day" text box as dddd.

Hope this was of some help.


Graham.