Link to home
Start Free TrialLog in
Avatar of Melvinivitch
Melvinivitch

asked on

Date field format in DataGrid bound to Access Database. VB6.

I have a DataGrid control bound to an Access database with several date fields. I want the dates in my datagrid to display with the zeros, such as "06/14/2004", "09/01/2003", etc... Unfortunately it seems that Access only allows me formats that strip the leading zeros from days and months: "6/14/2004", "9/1/2003", etc... Is there any way around this? Either in the datagrid display, or in the table in Access?
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

This is unrelated to MS Access.  The Format in the table is striclty an Access thing.  You need to format the value in the data grid.
Avatar of Melvinivitch
Melvinivitch

ASKER

It's unrelated to Access but the Format in the table is strictly an Access thing? ... Not sure I follow...

And how do I format the values in the data grid?
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial