Hello,

I am using SQL server so all my dates get returned as datetime values. I am only interested in the date portion. For forms, I have created a class that handles this well - puts the TTOD() value in the textbox at refresh and updates the datetime field in valid() - works fine. HOWEVER - I am struggling with how to handle this in a grid. My class won't display anything there.

I want the grid to SHOW ONLY date portion of value, be updatable, and only allow DATE portion to be entered. If I set column source to TTOD(myfield), the column becomes read-only - if I set the column to myfield and the individual textbox to TTOD(myfield), I still get the whole darn datetime value in the box! How are others handling this? what's the secret?

Thanks!
Ken