Access: Form Design Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Form Design Tools ->Design -> Combo Control

 

 

 

 

The Combo Box Wizard

Which Table?

Choose tblRating. Go to the next step.

 

Which Fields? 

Use the right arrow to move the Rating Field from Available to Selected.

Go to the next step.

 

Any Sort?

The Combo Wizard will ask if you want to sort the fields. It isn't important with this table. Go to the next step.

 

How Wide?

You should see a preview of your Combo Box. Does it fit?

 

Memo to self: If the column is too narrow to see all of the words on the list, you can drag the right edge of the column wider.

 

  Microsoft Access 2007 Exam 77-605 Topic: 2.  Creating and Formatting Database Elements 

  2.7. Modify the design of reports and forms   2.7.4. Format controls