>>Any ideas on how to put a date field in a grid textbox with this format? Or am I 'barking up the wrong tree' trying to do this?
>
>That's not very specific, let's try again...I have the datetime field in the column using TIME() but the time is showing HH:MM:SS.Milleseconds. I've tried to set seconds OFF in both the textbox and with SET SECONDS, but neither of them work. ???
>
>It's an editable field so I can't split into parts with other functions like HOUR()...

Why do you use a datetime field? Can't you use 2 fields: date and time (char field)?

Vlad