Access ActiveX Control-Calendar

[ulnaoar]

Hi, anybody knows how to set the value for a calendar(activeX Control in Access)? I want to set the default date as today, but it doesn't allow me to use any function but only a specific date like "08/10/2005". Any help is much appreciated!

 

[mp9]

Instead of setting it to a specific date, try setting it to Date()

http://www22.brinkster.com/accessory/

 

[ulnaoar]

Hi, I tried but it didn't accept any function but a specific date. After I input "date()" and close the window, it didn't save and just left the value column blank. Thanks!