How to save data as General Date with only short time show on form?

[solar115]

I have some project run on MS-Access as front-end with database linked to MS-SQL Server. I have some column of table contain Date-Time data that store data as General Date format (ie 01/01/2005 08:00:00). I create some form for my staff to key in a data of lab test that they will be key in only time with out date value. On form, I show this value as time only too. But I want to use this data with Date value for some calculate as backgroud process.

So...

In case of new data, Database will be store my data as CurrentDate with Time that my staff key in.

In case of data update, Database will be store my data as ExistDate with Time that my staff may update.

What should I do for solve my problem?

 

[MSAccessUser]

You can select the Format of your text box to Short Date. This will only show the date and not the time.

 

[solar115]

In my focus, I want to show only time without date that I can select format as ShortTime

I got only time when data saved but I want it to save both date and time.