Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time Input Mask

Status
Not open for further replies.

Kindi

Programmer
Jan 31, 2001
54
0
0
GB
Hi

I have 2 fields called start and end time, they are date/time datatypes, and when i have created the form i have put the short time input mask. BUT when i run the form it is the long time input mask (which includes seconds).

This is the input mask code in the property sheet for the 2 fields:

00:00;0;_

I also tried this input mask:

00:00

This didnt work either!

I am not sure what to try out next, any suggestions?

Thanks
 
Is this what you want?

Format(time, "hh.mm.ss") or Format(time,"hh.mm")(

rollie@bwsys.net
 
Hi Kindi,

I am not sure why you are having troubles, I have a db with this exact same situation and I am using the same format as you originally typed in (00:00;0;_) and my time displays as Short Time instead of long time.

Regards,
gkprogrammer




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top