>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()...