Spacing of Fields on Access2007 forms

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nhrockman
    New Member
    • Mar 2012
    • 2

    Spacing of Fields on Access2007 forms

    When creating forms using Access2007, if I draw fields from a query, table, etc. such that it is a bound field, I find it difficult to insert an unbound field between them in the design view. Played with padding in Properties. Is there a property that keeps those fields together?
    Looking for a way of "undoing" formatting, inserting new fields, shifting the fields around, and then reinstating WITH the newly inserted unbound field.
  • Mihail
    Contributor
    • Apr 2011
    • 759

    #2
    After the form is created switch to Design View and click somewhere in form's area.
    Press CTRL + A . This will select all controls in form.
    Switch to Arrange tab (ribbon)
    Under Control Layout section you will find the Remove button.
    Click this and you will be able to (re)arrange controls as you wish.

    Comment

    • nhrockman
      New Member
      • Mar 2012
      • 2

      #3
      Thanks Mihail. You got me on the right track.
      I just selected the fields that I wanted "to release" and then hit the REMOVE button.
      Found the "answer" to the 2nd aspect of my question: "reinstatin g the FORM aggregation of the fields in the same area.
      Again, selecting the fields that you want [CTRL+A for all fields, SHIFT + fields desired for JUST the fields selected]; and then
      Selecting "Stacked" or "Tabular" seemed to aggregate them together (sort of the like the functionality of GROUP in PowerPoint).
      Playing further with selecting fields, using combinations of "Remove", "Stacked or Tabular" and the "Control Padding", I've got back control of the creation of my form while being able to use the newer form creation tools. Thanks again for sharing your insight!!

      Comment

      Working...