Thanks Hack and Sethindeed

Thanks Hack
I don't know why but Sethindeed method didn't work.
Can you tell me Hack how to format the recordset element containing the date before the grid gets populated.

Thanks for your time

You will need to know what element in your recordset contains the date, but that should be easy to determine. For the purpose of this example, I'm using a recordset name of simply Rs and the date is contained in the first element (Rs(0)). Change Msgbox with the appropriate MSFlexGrid Row and Column

VB Code:

MsgBox Format(Rs(0), "mm/dd/yyyy")