DatePicker Control

[Guest]

Using a DatePicker control on a form and trying to set initial date when form
opens to a specific date...such as:
Me!axdtpFundStart = "10/31/97"

The reference
http://msdn.microsoft.com/library/d...on98/html/vbconusingdatetimepickercontrol.asp

implies this can be done. However when form opens, I get error message that
says the property is read only. Any ideas?

 

[Tom Lake]

Using a DatePicker control on a form and trying to set initial date when form

opens to a specific date...such as:
Me!axdtpFundStart = "10/31/97"

The reference
http://msdn.microsoft.com/library/d...on98/html/vbconusingdatetimepickercontrol.asp

implies this can be done. However when form opens, I get error message that
says the property is read only. Any ideas?

Have you tried:

Me!axdtpFundStart.Value = "10/31/97"

Tom Lake

 

[Guest]

Yes...tried specifying the property using .value; also tried without...no
difference.

 

[Guest]

Found solution...you can set the control value on Form_Load event but not
Form_Open event. Interesting...

 

[RD]

Using a DatePicker control on a form and trying to set initial date when form
opens to a specific date...such as:
Me!axdtpFundStart = "10/31/97"

The reference
http://msdn.microsoft.com/library/d...on98/html/vbconusingdatetimepickercontrol.asp

implies this can be done. However when form opens, I get error message that
says the property is read only. Any ideas?

The Windows DatePicker control drove me bats with it's antics. I found a nice
one from Brendan Kidwell that works pretty good here:
http://www.glump.net/dokuwiki/software/microsoft_access_date_picker

HTH,
RD