Control to pick time on access 2007 form.

danmccarthy74,

In Access 2007, whenever you create a Date Field, (A field that specifically has a DataType of "Date/Time"), you will always get a "Date Picker" by default, whenever you click on that field.

(No special Control or Code is required)

;-)

See attached screenshots:

JeffCoachman
untitled01.JPG
untitled02.JPG

Just click the DatePicker, and you get a calendar like this:

untitled03.JPG

I've gotten that far, but what I'd like is a control that allows the user to pick the time of day (HH:MM). As far as I can tell, there is no option for the default date/time picker to allow time selection.  I don't want to record the hours and minutes in real-time; need to allow the user to specify any time.
Thanks!

Great, I will try this.  I had already resigned myself to combo boxes, but they would have been clunky the way I had it planned in my head.  I was going to have seperate boxes for hours and minutes and then concatenate them.  But I was worried working with resulting values was going to be more trouble than it was worth.

Adding the time value to the date will make it much easier to set up and then work with the results.
Thanks again!

You can round these values to 4 decimal palces an you will get some nice numbers(ex.: 12 noon=.5000, 6PM=.7500)
0.0000
0.0104
0.0208
0.0312
0.0417
0.0521
0.0625
0.0729
0.0833
0.0937
0.1042
0.1146
0.1250
0.1354
0.1458
0.1562
0.1667
0.1771
0.1875
0.1979
0.2083
0.2187
0.2292
0.2396
0.2500
0.2604
0.2708
0.2812
0.2917
0.3021
0.3125
0.3229
0.3333
0.3437
0.3542
0.3646
0.3750
0.3854
0.3958
0.4062
0.4167
0.4271
0.4375
0.4479
0.4583
0.4687
0.4792
0.4896
0.5000
0.5104
0.5208
0.5312
0.5417
0.5521
0.5625
0.5729
0.5833
0.5937
0.6042
0.6146
0.6250
0.6354
0.6458
0.6562
0.6667
0.6771
0.6875
0.6979
0.7083
0.7187
0.7292
0.7396
0.7500
0.7604
0.7708
0.7812
0.7917
0.8021
0.8125
0.8229
0.8333
0.8437
0.8542
0.8646
0.8750
0.8854
0.8958
0.9062
0.9167
0.9271
0.9375
0.9479
0.9583
0.9687
0.9792
0.9896