Datasheet

Designing Applications
31
3.
Access will now generate a form with all the fields from the tblCompany table and
display the first record:
This is OK, but it's not perfect. There are several things that we can improve:
❑ The form caption is tblCompany, which isn't very instructive to the user.
❑ We will probably want to hide the CompanyID field, as it's of little relevance to the user.
❑ Some of the fields are the wrong shape. For example, we will want to make the
Address textbox taller, to accommodate larger addresses.
❑ The navigation buttons at the bottom of the form are a bit small and fiddly – this is a
key form and must be as easy to use as possible.
So let's change the form so that it looks a little more professional.
Try It Out Changing a Form's Appearance in Design View
1. Save the form you've just created by choosing Save from the File menu or by hitting
Ctrl + S. A dialog box will appear allowing you to type in a name for the form. Call it
frmCompany: