Hello: I have created a combo box on a form. The row source of the combo box is a table called dbo_Timestbl. It has two fields; 1. Timesfld, which holds all military time i.e., 06:00, 06:30, 06:45.....23:00,. The second field is called Timesnocol which is the exact duplicate time list but without the colon, for example it has 0600, 0630, 0645,...2300. Users click on the drop down and select the time the time slot they desire. It works great! However, it faster for the user to begin typing the time and have Access complete including the colon. In other words users should be able to type the Timesnocol time but have Access select the corresponding time from the other field which includes the colon. For example, if I were a user I could type 0600 and tab to the next field on the form. In this example Access should select 06:00 from the other field in the table and store that value rather than the 0600 which was typed by the user. As it stands now, when I type in the complete time without the colon I receive an error message stating that the value is not on the list. I then have to stop and physically add a colon or scroll down the list and select the correct time with the colon. This may not seem like a big deal but every second counts and speed is on demand. Users don't want to stop and add the colon or even scroll down the list to select the time...they would rather not have to break the momentum and type the time without the colon. We need to have the time with the colon stored because it's used on a report that follows the form. Can anyone offer any suggestions? * Tables are on lockdown therefore I cannot modify the design of the table.