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

strange date 12-30-1899 shown

P: n/a
Hi all,

One field of Access table is date/time type, and format is long time.

In VB.NET, as this table linked to a datagrid, a strange date 12-30-1899 is
shown instead of the time expected. What should I do to let it show time
only?

Thanks.

--
Best regards,
RL
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Lurc" <lu*****@spam.hotmail.com> schrieb

One field of Access table is date/time type, and format is long
time.

In VB.NET, as this table linked to a datagrid, a strange date
12-30-1899 is shown instead of the time expected. What should I do to
let it show time only?


12/30/1899 is the date stored in the database field. Access doesn't show the
date, the Datagrid does.

Set the Format property of the DatagridTextboxcolumn object in the
Datagrid's tablestyle.
See the paragraph "To format the text of a column..." @
http://msdn.microsoft.com/library/en...ClassTopic.asp

Maybe also:
http://msdn.microsoft.com/library/en...DesignTime.asp

Armin

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.