Set date to Date and time picker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 15 Mar 2007 09:24 GMT

Hello there

I have access application with Date and time picker object inside.

I can bound it to table. But i can't set value to it.

I tried this
Sub Form_Load()
me.txtArrivalDate = "07/01/2005" 'July the first
End Sub

I got this error: Date and time picker error: Property is read-only

How can i set value to date and time picker?

Reply to this Message

missinglinq - 15 Mar 2007 15:03 GMT

I'm confused, Roy! You appear to be trying to set a default date to your
Date/Time picker, but you're trying to assign a date to a textbox control. If,
in fact, you're trying to set a value to the date picker, try this, where

YourDatePickerName

is the actual name of your date picker.
Private Sub Form_Load()
Me.YourDatePickerName ="07/01/2005"
End Sub

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message