G
Guest
BACKGROUND:
I have a Access Database that provides the basic structure for a new data application I have been asked to develop.
I chose to develop the front end in VB 6.0 rather VBA because a wider variety of controls are available ( even if I have to develop them from scratch).
THE PROBLEM:
When displaying data from a table the date is displayed in American format (mm/dd/yy) rather than my regional setting of dd/mm/yy. But I also have another table in the database that was added at a latter stage on not the orginal machine that displays correctly. The strange part is that if I display the same non-cooperative data in a DataGrid control, it is displayed as I want it (dd/mm/yy)
WHAT I"VE DONE SO FAR:
I added a text field to the database and updated it's value to Cstr(Date) (displayed correctly) then added another date field and updated that to cdate(DateString) ... no joy ...same problem. I did the same thing but in a totally new database... still no joy
Suggestions Please!!!!!!
TIA
Dene
I have a Access Database that provides the basic structure for a new data application I have been asked to develop.
I chose to develop the front end in VB 6.0 rather VBA because a wider variety of controls are available ( even if I have to develop them from scratch).
THE PROBLEM:
When displaying data from a table the date is displayed in American format (mm/dd/yy) rather than my regional setting of dd/mm/yy. But I also have another table in the database that was added at a latter stage on not the orginal machine that displays correctly. The strange part is that if I display the same non-cooperative data in a DataGrid control, it is displayed as I want it (dd/mm/yy)
WHAT I"VE DONE SO FAR:
I added a text field to the database and updated it's value to Cstr(Date) (displayed correctly) then added another date field and updated that to cdate(DateString) ... no joy ...same problem. I did the same thing but in a totally new database... still no joy
Suggestions Please!!!!!!
TIA
Dene