Create a form based on a table in ms access 2007 Form Wizard

How we deal with unanticipated changes, personally and professionally often determines our level of hapiness.

In the software development arena languages and tools like ms-access evolve relentlessly.

ms access form menu item image

ms access form menu item image

One such change involves the default behavior of form creation used by the form wizard in ms-access 2007.

To automatically create a form based on a table

First open the navigation pane (found on the left normally). View all access objects. Choose a table by selecting one in the table section of the navigation pane. then go to the Create tab on the menu bar at the top of your screen next to ‘Home’. There look for the ‘form’ image. The ‘form’ icon is next to the ‘split form’. Click on form. Ms-access will create a form based on the table. Neat huh?

The above did not involve the ms-access 2007 form wizard.  To use the access form wizard do this:

How to use the Ms-Access Form Wizard

how to open the ms-access forms wizard

From the create tab, open the ms-access forms wizard

Unlike the prior exercise, you do not have to open the navigation pane or select a table. Instead, just find the ‘Create’ tab. To find the create tab,  look up at the top of the ms-access menu bar.  Find the section where ms-access  ‘Form’ menu item image is. To the right of ‘Form’ you will see “More Forms”. Click on “More Forms” to expand the selection.

The first option you should see is ‘Form Wizard’. Click on the ‘Form Wizard’ to launch it.

In the dialog form that comes up, you are prompted to choose the table you want. Note if you want a form based on fields in more than one table, you will have to create a query and then select that query during this phase. You can make queries on any number of tables. In the most common usage, you would have to make sure there is a field you can ‘join’ the two tables on.  For example, the products table has a product id primary key and the product_types tables has within it, a related field productid. This is a type of constraint known as a foreign key constraint. You can set these types of join relationships easily in the database tools menu, under ‘relationships’.

In the ms-access 2007 forms wizard, choose the table or query you want to base the form on

In the ms-access 2007 forms wizard, choose the table or query you want to base the form on

Moving along, once you have selected the table or query you want you can choose the fields you want in your new form.

Select the “>>” to choose all the fields. Don’t worry you can remove any ones you don’t want later by choosing the edit in design view later.

Form Wizard What Layout Columnar

Form Wizard What Layout Columnar

 After select the layout you want next choose the style. Select ‘Flow’ or something of your own choosing.

Finally select the title.

Form wizard what title do you want

ms-access 2007 form wizard, what title do you want

You can ‘Modify the form’s design’ to see it in design view.

 You might see something like this for example.

example of design view in ms-access 2007 produced by access form wizard 2007

example of design view in ms-access 2007 produced by access form wizard

How to stop tandem resizing of controls

Try resizing one of the text boxes. After creating a new ms-access form, the user who wants to resize one control will be perplexed. The resizing of one control, while in design mode, results in all the controls being resized in tandem.

Some like this feature. Some don’t.  Another developer mentioned to me his lack of enthusiasm for this feature. Some people think its a bug!

Well if you don’t want your ms-access controls to be resized all at once then there is a solution.

  • While selecting the textbox
  • Go the Arrange tab
  • Choose remove

After you do this, you can now move the controls around individually.