By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

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

P: n/a

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

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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.