Question

Locked

Acess 2007 Create Form Wizard

By Rod.Wright ·
The Access 2007 Create Form Wizard makes it easy to create a default form. Unfortunately it seems to be set so that the width of each field is linked to the others. When I click on the handle to adjust the width of an individual field, all others also adjust by the same amount. Does anyone know the setting needed to unlink the field width so I can individually adjust each field?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

create the form first

by john.a.wills In reply to Acess 2007 Create Form Wi ...

Once the form is created, you can highlight any control and change its size. I did not know that this could not be done in the wizard.

Collapse -

Yes You Can...but

by Rod.Wright In reply to create the form first

Yes, you can click on any field and use the "handle" to change the display size for the field. In Access 2003, that just changed the selected field. But in a form created by the Wizard in Access 2007, changing the field width of one field changes all of the others too...an undesirable trait. There must be a setting somewhere but I have not seen it.

It sorta spoils the usefulness of the Wizard for me.

Collapse -

Break the spell

by briantshea In reply to Acess 2007 Create Form Wi ...

It's 'layout' and it's a nuisance.

In reports, when the fields are linked, you can select them, and then cut and paste them back in the report. This breaks the link on the fields to each other that ties their sizing and positioning to other objects.

To do the same thing in Forms, select the fields in Design view, rt click, and go to 'Layout' and select "Remove". (It's 3rd, under 'Tabular' and 'Stacked')
This allows you to manipulate individual form field size/position.

Back to Software Forum
4 total posts (Page 1 of 1)  

Software Forums