MSFlexGrid problem!

[Harmough]

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.

[Ober]

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

[Harmough]

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.