Do you find yourself constantly typing the same data in the same field? For example, say you work with an Employee Data form, and you find that you’re typing the same three Zip codes repeatedly. Since most of your employees live near your company’s three offices, you seldom need to type any other codes. By converting the Zip code text box into a combo box, you’ll eliminate the retyping. Follow these steps:
- Open the form in Design view.
- Right-click the Zip/Postal Code text box.
- Move to Change To and click Combo Box (Figure A).
- Right-click the Zip/Postal Code combo box.
- Click Properties (Figure B).
- On the Data tab, click the Build button in the Row Source field (Figure C).
- Add the Employees table.
- In the field list, double-click Zip/Postal Code.
- Click in the Criteria box under Zip/Postal Code and enter Is Not Null (Figure D).
- Close and save the query.
Now you can simply select one of the three zip codes from the drop-down list in the combo box, as shown in Figure E.
Miss an Access tip?
Check out the Microsoft Access archive and catch up on other Access tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.