Hi Yin --
Go to the parent Column and set the Sparse property to False. This will ensure that the column always displays according to it's TextBox's settings.
>I have a textbox under a grid. This textbox is used to display a date. I set the DATEFORMAT to 11-DMY, and SET CENTURY ON. What I expect to see the date displayed is dd/mm/yyyy. But, when the focus is not in the textbox, the display is mm/dd/yyyy, if the focus is in the textbox, the display become dd/mm/yyyy, which is correct.
>
>Can anyone tell me how to make the display consistant as what i set in the DATEFORMAT.
>
>Thank you in advance.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05