Time Field in Access

This topic is locked

Time Field in Access	2/13/2006 10:02:01 AM
ASPRunnerPro General questions
C Chad author I have an access table with one of the fields being a TIME (format: medium time) so it shows as 2:00 PM. I am unable to use either ADD or EDIT a time on the web. All other fields in the table work fine. Can add records, edit records, but the time stays blank, no matter what I do. I have tried many different combinations of settings in ASPrunner under the EDIT AS column along with the EDIT format. What would be the proper combination to make TIME work.


	Sergey Kornilov admin 2/13/2006
	Chad, I recommend to use Datepicker with Time edit box which is available in ASPRunnerPro 4.0. Please note that there is no such thing as Time field in MS Access. Even if you set Format to Time it's still a regular Datetime field. MS Access just drops date part when displaying this field. If you need to enter times you can use simple Text field.