Software

Save a million keystrokes by turning Access text boxes into combo boxes

If you repeatedly type the same text in the same field, you're working too hard. See how to set up a combo box that will speed data entry and spare you a TON of tedious typing.

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:

  1. Open the form in Design view.
  2. Right-click the Zip/Postal Code text box.
  3. Move to Change To and click Combo Box (Figure A).

    Figure A

    combo

    1. Right-click the Zip/Postal Code combo box.
    2. Click Properties (Figure B).

      Figure B

      properties

      1. On the Data tab, click the Build button in the Row Source field (Figure C).

      Figure C

      build button

      1. Add the Employees table.
      2. In the field list, double-click Zip/Postal Code.
      3. Click in the Criteria box under Zip/Postal Code and enter Is Not Null (Figure D).
      4. Close and save the query.

        Figure D

        criteria

        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.

        Figure E

        combo box


        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.

        Editor's Picks

        Free Newsletters, In your Inbox