Advanced feature. Adding a Combo box for Salute

• As you will realise Salute has a restricted number of choices (Mr, Mrs, Ms, Dr, Other). It would be better to allow a user to choose from the a list in a Combo box.

• To do this we will add a new data entry label and drop down combo box to our form

• Steps:

• Change to Design View and click on Combo box then drag over the form below the mobile phone entry

• A "Combo Box wizard will appear and you need to select "I will type in the values I want"

• Enter the values then click [Next]

• Change the Label to "TitleT" then [Next]

• Change to Form View

• You will now be able to select the Title from a drop down combo box.

• Notice that when you select a value the EmpTitle data (above) will also change.

Tidy up the form and form objects

• Good practice is to tidy up some of the things that will make it easier for the user and the programmer.

• For the user you can delete the empSalute label and text box (click on them and tap the [Delete] key) and move the Salute Label and combo box into its place

• For the programmer you should change the Name of the combox box used for Title to cboEmpTitle. (Design View > Click on Combo Box, then in the Property Sheet , select the [Other] tab and change Name to "cboEmpTitle")

Activity: Personalise your form

You can modify the form to

• make the labels clearer, for example change "empLastName" to "Last Name"

• Add rectangles to create groups (e.g. Address)

• Change background colours (e.g. For Detail click on the "Detail" bar and in the Property Sheet change "Back Color".

• Add an image or logo ( A logo is best added to the Form Header).