Date Format in Grid Textbox

[Scott24x7]

Hi All,
I'm having a problem with the display of dates in textboxes in a grid. I'm baffled.
I have dates in text boxes in the form that display the dates as I expect (We use Japan format, with full century, so today's date would display as 2018/10/11 (October 11, 2018). But the same field in the grid on the form displays as 10/11/18 - US date format. I have set the DateFormat property in the textbox in the grid to 7 - Japan. Century is also set on.
At the system wide level I have the date format set to Japan as well. But the text box in the grid doesn't seem to recognize it at all.
Any ideas?

Best Regards,
Scott
MIET, MASHRAE, CDCP, CDCS, CDCE, CTDC, CTIA, ATS

"Everything should be made as simple as possible, and no simpler."

 

[atlopes]

Set the .Sparse property of the Column to .F.

 

[Scott24x7]

Hey Atlopes, that worked! BUT... now it's not setting the dynamic back color after the change.
(That's an annoying property... I had no idea it affected the display of dates).

Best Regards,
Scott
MIET, MASHRAE, CDCP, CDCS, CDCE, CTDC, CTIA, ATS

"Everything should be made as simple as possible, and no simpler."

 

[Scott24x7]

Ah, found it... now have to set the textbox backstyle to Transparent instead of the default Opaque.
Sometimes the grid behaviour is really non-intuitive.


Best Regards,
Scott
MIET, MASHRAE, CDCP, CDCS, CDCE, CTDC, CTIA, ATS

"Everything should be made as simple as possible, and no simpler."