another date question

S

smk23

My backend is SQL server 2k and I'd like to display only the time portion of
a datetime field. Although I can set the format to whatever I want, when the
user wants to edit the time, they can see the entire field with the date and
seconds, etc. If I format the time in the control source, the time is no
longer editable. How can I display just the time and retain ability to edit?

Thanks!!
 
Top