Format a date or string in MSHFlexGrid

[rogergho]

Hi Guys,
can you please tell me how to Format a date or string in cols in a MSHFlexGrid (dd/mm/yyyy)

[Hack]

How does the date get put into MSFlexGrid?

I'm thinking that if you are populating the MSFlexGrid based on the return of a recordset, you could format the recordset element containing the date before the grid gets populated.

If the date is being input via a Text box, then, again, you can format it before the code you have to place it on the grid.

[sethindeed]

MSHFlexGrid.TextMatrix(YourRow, YourCol) = Format$(MSHFlexGrid.TextMatrix(YourRow, YourCol) ,"mm/dd/yy")

[rogergho]

sethindeed, can't i just format a whole col instaed of every cell ?

[rogergho]

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

Thanks for your time