×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Date Format in Grid Textbox

Date Format in Grid Textbox

Date Format in Grid Textbox

(OP)
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."hammer

RE: Date Format in Grid Textbox

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

RE: Date Format in Grid Textbox

(OP)
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."hammer

RE: Date Format in Grid Textbox

(OP)
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."hammer

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close