Flexgrid Data Format.

I have an Access database whereby Date's are stored in the form of dd/mm/yy.
Whe retreived into Flexgrid, they appear in the form of mm/dd/yyy. How can get them shown on datgrid in the form of dd/mm/yy.
Thanks

Use Format function:

MsFlexGrid1.TextMatrix(row, col) = Format(your_date_filed, "mm/dd/yy")

@tendemo:

For your information, in most databases, dates are stored as long integers or fixed numbers. What you're seeing (dd/mm/yy) is the display, not the storage. Regardless of how you tell the database program to display the dates, the internal storage (and the data your program retrieves) remains the same.

G Thanks for the format and the information will work on all right away. A la prochain.