Access Form using Date Picker (MSComCtl2.DTPicker.2)

[Andreas Belitz]

Hello,

in my project, i use a form with Microsoft's Dte Picker Control
(MSComCtl2.DTPicker.2). This control is linked up to a date field of a
table. When i open the form, the control always displays its default
date value set in the properties and not the date of the appropriate
column of my table. Using VBA and "msgbox"'ing the value of the
control, it shows the right value (the one from the table):

in the table (1st record) the date field (myDateField) is 30.01.2006
(german notation of 2006-01-30). The "Value" property of the control
on my form (myDatePickerControl) is 01.01.2006.

MsgBox myDatePickerControl.Value

on the OpenForm event gives me
30.01.2006

the control, however displays 01.01.2006 on the form.

Am i doing anything wrong? BTW: if this matters: the control is
sitting on a tabstrip control (don't know the english name... not the
Forms.TabStrip.1 control, but the one directly from the toolbar).

Thanks for any help in advance,

Andreas Belitz