Time Picker

[Sahil]

Hi

Do we have an exclusive Time Picker only, I am using the Calendar control for selecting date, Is there any similar control which will help the user to select a particular time instead of manually entering it?

 

[Steve]

There is another Active X object called Microsoft Date
and Time Picker Control. It looks like a combo box but
when you click on it a calendar pops up.

 

[Sahil]

Thanks Steve, but I need a control which display's time only. I want the user to select time along with the date. Can you please advise?

 

[John Silver]

Thanks Steve, but I need a control which display's time only. I want
the user to select time along with the date. Can you please advise?

You can set the format to "custom" and display only the time on that
control. Use the options from Visual Basic Help (MSDN) instead of the
format syntax from Access Help to make it work. Just click the help
button when you're in the properties dialog for the custom value.

I prefer to have both date and time in the same control; it still
allows to pick a date from the calendar view. The format I use is:

"M/d/yy h:mm tt" which displays like "3/7/04 11:00 AM" .

Just use "h:mm tt" for 12 hour time but enclose the letter codes in
single quotes when you enter the format like 'h':'mm' 'tt' . Details
in the help file.