Solved

Auto align fields in Design View Access 2007

Posted on 2009-05-03
8
694 Views
Last Modified: 2012-05-06
Hi,

I created a form and I was trying to expand some fields. I notice that when I do the fields overlap and then I can't see the other fields. I know there is a way so when I select a field to expand it the other adjacent fields will automatically adjust and move to allow room for this newly expanded field.

Much thanks,
vkimura
access-auto-align-fields.png
0
Comment
Question by:Victor Kimura
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 46

Assisted Solution

by:tbsgadi
tbsgadi earned 100 total points
ID: 24289335
Hi,
Try Selecting all the controls & then doing Format > Vertical Spacing > Make equal

Gary
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 24289342
see this link
     http://allenbrowne.com/casu-05.html
0
 
LVL 84
ID: 24289450
<I know there is a way so when I select a field to expand it the other adjacent fields will automatically adjust and move to allow room for this newly expanded field.>

There is no automatic method to do this while you're sizing or adding controls, but as Gary said you can use the various Format and Align functions to help with the process.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 100 total points
ID: 24290070
0
 
LVL 84
ID: 24290139
Cool! Wasn't aware of the new "anchoring" feature in 2007 ...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24290716
Scott,

Yeah I was pretty impressed with this as well.
...but get ready for the "Anchoring" questions in a few months...
:-O

BTW, Pete states that "Export To Excel" is back in Off07 sp2.
I'll be loading it tomorrrow.

Jeff
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 300 total points
ID: 24290857
vkimura2007,

There are a lot of options in Access 2007 for designing forms and controlling the Design/Layout.
For example
<re. http:#a24289335>
Has been replaced with an Icon (see screenshot #1)

Also, by default in Access 2007, Reports and Forms have what is called a "Layout".
This is designed to keep your form looking uniform, when controls a removed, added or resized.
So depending on your design, resizing one control, may cause another control (or controls) to grow as well. This may be what is happening to you.
This may not be what you want.

In such cases you may have to remove the "Layout" in order to manipulate individual controls to customize the form.

To do this, select all the controls you want to move/resize (or press Ctrl-A to select all of them), then click: Arrange-->Control Layout-->Remove.
(see screenshot #2)

This is the reason why users new to Office 2007 should always obtain a good *basic* reference book on Access 2007 (*NOT* a "Developer" or "VBA" book).
There is just so much that can trip you up, if you don't know the basics.
(I like the "Bible" Series personally)
Access 2007 Bible:
http://www.amazon.com/Access-2007-Bible-Michael-Groh/dp/0470046732/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1221793034&sr=1-1
Access 2007, step by step:
http://www.amazon.com/Microsoft-Office-Access-2007-Step/dp/0735623031/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1221793077&sr=1-1
Access Inside Out:
http://www.amazon.com/Microsoft%C2%AE-Office-Access-Inside-Microsoft/dp/0735623252/ref=pd_bbs_sr_2?ie=UTF8&s=books&qid=1241376386&sr=8-2
Access Special Edition:
http://www.amazon.com/Special-Using-Microsoft-Office-Access/dp/0789735970/ref=pd_bbs_9?ie=UTF8&s=books&qid=1241376386&sr=8-9

;-)

JeffCoachman

untitled01.JPG
untitled02.JPG
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24290927
As you can see there are litterally dozens of options regarding Layout and design.
(Not to mention the new properties.)

So you really must get a reference book and study it well.
;-)

Jeff
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

742 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question