Expert: Scottgem - 7/8/2009

Question
I have created a form with the Access 2007 forms wizard.  The form has the fields laid out in 2 columns. I want to make the first data field in the first column about twice as wide as the wizard created it. If I try to expand the length of the field, the entire column of fields gets wider, not just the field I clicked and selected.  The fields appear to linked as a column. How do I break the link so that I can manipulate each field individually?

Answer
First, you don't have fields on a form. You have controls that may or may not be bound to a field in a table. This is a subtle but important distinction.

Access 2007 does group controls for a more uniform appearance. Its a feature I dislike, though it does have advantages. You can ungroup the controls under the Arrange tab when in Form Design mode. In the Control Layout section, you will see a Remove icon that removes the crouping.

Hope this helps,
Scott<>