strange date 12-30-1899 shown

[Lurc]

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.

 

[Armin Zingler]

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-us/cpref/html/frlrfSystemWindowsFormsDataGridClassTopic.asp

Maybe also:
http://msdn.microsoft.com/library/en-us/vbcon/html/vbtskFormattingtheDataGridAtDesignTime.asp

Armin