Printable View
I've linked a MSFlexGrid control with a MS Access 2000 database. This database has a date/time field with a user-defined notation of "d mmmm yyyy". But in my FlexGrid control, the date is listed as "dd-mm-yy". How can I set it to "d mmmm yyyy"?
Thanks in advance!
Dave.
I don't know what the notation of d mmmm yyyy is but I think the standard Date format of Access is dd-mm-yy so if you're database if formated as a date then it will convert information like mm/dd/yy to mm-dd-yy and so on.
If you want the Grid to show exactly what was entered into the datebase then change the format of that column to Text.
I hope that works...
-Ober
Well, I'm dutch so "d mmmm yyyy" is "9 oktober 2000" and Access shows the date correctly in the fields, but somehow the Flexgrid control converts it to the standard "09-10-00" format. Now, I can set the Access field type to Text, but then I won't be able to sort the field on date. So I want to format the row or column of the Flexgrid control to show the date in the "d mmmm yyyy" format.
Thanks anyway!
Dave.