date and time picker control 6.0 (sp4) --- MS Access

[MUKESHY12390]

Hi All,

I would like set "Date Picker" default value to today.But every time I open form get error "DTPicker returned the error: Property is read-only."

Any idea or suggestion most welcome.

'''Access form
Private Sub Form_Open(Cancel As Integer)
Me.DTPicker0.Value = Date
End Sub

 

[Joe4]

See:
Getting a date picker to default to current date | dBforums – Everything on Databases, Design, Developers and Administrators
and
Default value for Date Picker - Microsoft: Access Forms - Tek-Tips

 

[MUKESHY12390]

thanks a lot.

 

[Micron]

You might want to delve a little bit into the difference between a form Open event and the Load event. It's a common mistake to try to affect form controls or records in the open event. Think of the form as the trunk of your car and your groceries as control values. You cannot load the groceries until you have completed the open trunk event.

If you can remember that properties of controls (such as their borders, visibility, etc) can be affected during the open event, but their values cannot be programmatically affected in the open event, it will help you in the future.

 

[MUKESHY12390]

no doubt it gonna help me in future ...thanks a lot