Arranging items in a form

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

This is a beginner's question, I suppose. Still, I can't find an answer on
the advanced group search, so here goes ...

What is the most efficient way to layout textboxes and their labels on a
form? I have dragged a number of fields from the field list onto my form. My
main problem is getting the label and the text boxes to sit equal distances
from each other for all ten or so fields. It seems a bit of a laborious
process if one has to tackle each field individually. I am sure there must
be a quicker way.

Is there a good site which would offer tips on this sort of basic
formatting?
 
Colin,

Try using the form wizard. It puts the label and the text boxes equal distances
from each other.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
Hi C Tate,

I have used this method for years now and it has been an immense time saver!
I forget where I got it, but I think it was here. If you google groups
using "format reports" you may come up with some other ideas.

These instructions apply to Access 2000, but they may work with variations
in other versions:

1. Create a new macro
2. Save it as Autokeys
3. Click View and select Macro Names
4. In the 1st Macro Name row, type: ^T
(^=control)
5. Click in the Action column, select RunCommand
6. In the Action Arguments section, click in the Command field and select
AlignTop
7. Repeat the above steps for all your formatting needs using a different
letter for each.
(note: stay away from common windows shortcut keys like "Ctl C, V &
X")
8. Once this is complete, you should be able to select any number of
controls in
a given section in Design view, and while selected, hold "Ctl" and
type "T". The
controls will align themselves to the topmost control.

I have a number of these set up for alignright, alignleft, alignbottom,
sizetotallest, sizetoshortest, etc.

HTH,

Jake
 
Hi Gitar,

Today is your lucky day - following is an immense time saver to what you are
doing!!!

Select multiple controls on a form. Cick on Format in the menu at the top and
you will find ways to align the controls you select, ways to space them
vertically or horizontally and ways to size the controls all built in to Access.
And here's the neatest trick, select a control on the left side of a form, hold
down the shift key and select a control on the right side of the form. You can
now do all that stuff with the controls you selected even if there are other
controls not selected between the ones you did select. You can do the same thing
with controls anywhere on the form.

Hope this makes your day!!

Steve
PC Datasheet
 
Hi PC,

Hey, thanks for the tip. I still prefer the macro though; it zaps a couple
mouse clicks. And when I'm zooming along, that is important!

Have a great day yourself! ~ :D

Jake
 
Back
Top