Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 705
  • Last Modified:

Auto align fields in Design View Access 2007

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
Victor Kimura
Asked:
Victor Kimura
3 Solutions
 
tbsgadiCommented:
Hi,
Try Selecting all the controls & then doing Format > Vertical Spacing > Make equal

Gary
0
 
puppydogbuddyCommented:
see this link
     http://allenbrowne.com/casu-05.html
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Cool! Wasn't aware of the new "anchoring" feature in 2007 ...
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now