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.