Active X Calender Control

[johnwiseman]

Hello.

I am using the Active X Calender Contol v8.0.

The date defaults to a date which is set in its properties/value. I wish the date to reflect todays date.

I have tried putting in =NOW() in the value but it appears this is not acceptable and I can only give a set date.

So is there a way this can be done?

Thanks in advance.

 

[mp9]

UNdoubtedly there is.

However, why use the clunky and resource-heavy calendar control. Why not use an Access forms-based alternative that you can then modify and tailor to your heart's content using standard Access form design tools and VBA ?

Take a look at

http://www22.brinkster.com/accessory/forms/005.shtml

for an example

 

[DJN]

In the forms Load event, put Me.txtMyCalendarControl = Date
Just change the name of the calendar control to your own.