AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
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.
