By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,572 Members | 2,949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,572 IT Pros & Developers. It's quick & easy.

Spacing of Fields on Access2007 forms

P: 2
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.
Mar 7 '12 #1
Share this Question
Share on Google+
2 Replies

P: 759
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.
Mar 7 '12 #2

P: 2
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: "reinstating 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!!
Mar 7 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.