Drop down question

My application has a drop down from which the user may select a Start
Time. This Start Time drop down has choices in it like 8:00 AM, 8:30
AM, and so on, for a normal business day. The list is pulled from an
Access table. As I was demo'ing the application a potential user
commented how nice it would be if he could edit in a time such as 8:15
AM. Is there a way that I can have this flexibility without actually
adding those additional times to the table? Most potential users
thought that half hour increments were fine but it would be great if I
could somehow allow this additional flexibility. Thanks very much.

"Cardinal" wrote in message
...
My application has a drop down from which the user may select a Start
Time. This Start Time drop down has choices in it like 8:00 AM, 8:30
AM, and so on, for a normal business day. The list is pulled from an
Access table. As I was demo'ing the application a potential user
commented how nice it would be if he could edit in a time such as 8:15
AM. Is there a way that I can have this flexibility without actually
adding those additional times to the table? Most potential users
thought that half hour increments were fine but it would be great if I
could somehow allow this additional flexibility. Thanks very much.


The combo box's LimitToList property controls whether or not you can enter
values that aren't in the list. That's on the Data tab of the control's
property sheet. If you set it to No, the user will be able to enter other
values than those in the list.

You may need to do a little work to ensure that the value the user enters is
a valid time.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)