>>>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)?
>
Actually, I'm not quite sure what I'm doing :~) I'm doing a timesheet app where the user must enter HH:MM in several places each day, the field should be blank until data is entered, then in HH:MM format. This is fixed in the design.

I've explored using date, numeric and char fields, but nothing has worked the way I'd like so far...I like the datetime because it has a builtin check against bad values...but I'm open to any ideas, especially if anyone else has done something like this already..