[AccessD] Alignment Issue

Greg,

If all the text boxes are the same height and have their frames aligned
and all the fonts are the same size, then the text will be aligned.
AFAIK Access does not have any way to automatically align text when all
those conditions are not met.  Maybe somebody else on the list knows of
a workaround for this.

IIRC Word is the only M$ product where you can align the baselines of
text, which is what you want to do.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Greg S [mailto:weeden1949 at hotmail.com] 
Sent: Thursday 2003 Aug 07 09:11
To: Wortz, Charles
Subject: Re: [AccessD] Alignment Issue


Charles:

A picture (or two) is worth a thousand words...

Attached are two images (pdf's), one of the report printed with red
lines below each 'row' to illustrate how they are 'expected' to be
aligned, and the other, with the report in design view (please pardon
the semi-crummy image...tried to reduce it as much as possible) with the
same red lines showing how it's aligned in the design view.  The
alignment (left, right, top & bottom) options will align the FRAMES of
the text/label boxes, but not the contents.

I want the contents to be aligned so the bottoms of the words in each
appear to be on the same line.  Where it says "Today:" on the left
column, the bottom of the word TODAY should line up with the bottoms of
the words in the remaining text boxes in that whole row.

And the column title "Real Estate Collected", which wrapped, should line
up with the bottoms of the words in the remaining column titles, like in
"E - Com Fee"...

If these attachments get stripped out of dumped, let me know, and I'll
send'em to you directly.

Thanks

Greg Smith
Weeden1949 at hotmail.com
----- Original Message ----- 
From: "Wortz, Charles" <CWortz at tea.state.tx.us>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, August 06, 2003 2:25 PM
Subject: RE: [AccessD] Alignment Issue


Greg,

There are align options for top, bottom, left, and right.  I have used
them all and they all work as expected.  To align all your labels on the
bottom, select all the labels and click on align | bottom.  If that is
not working for you, please give us more information about the problem
you are experiencing.

Charles Wortz
-----Original Message-----
From: Greg S [mailto:weeden1949 at hotmail.com]
Sent: Wednesday 2003 Aug 06 14:05
To: Access Developers discussion and problem solving
Subject: [AccessD] Alignment Issue

Hi everyone!  No comment on "William's Signature Line..." and the
...oops...almost...never mind.

I have a problem with aligning (vertically) labels and/or fields on a
report when there are (1) various font sizes being used and (2)
word-wrap in text boxes.

(1) For example, let's say I have a "table", if you want to call it
that, in a report, where the left column contains the row label
(identity) for everything in that row.  The remaining columns contain
fields from query results, sums, totals, etc.  I obviously can easily
align the like fields with each other.  The problem starts when trying
to align the left column labels, which are, for example, font size 12,
with the rest of the fields in that row, which are 10.  Aligning the
field/label boxes does NOT do the trick.  Because of the larger font,
that box has to be larger, in which case the letters sit up higher in
it, and don't align with the others any longer. Most of my clients don't
say anything, either out of politeness, or they think I'm a friggin'
idiot and can't even align stuff in a row.  I can see the misalignment,
but have never found a surefire way of making the letters truely align.
It's always bugged me, but today, just back from vacation, it's more
irritating than normal.

(2) And in a similar vein, when you have labels, which are, for example,
column headings, and some of them just fill the label box and some of
them wrap around because they're too long for the column width.  Ever
try aligning those dudes on the bottom?  Without doing it manually, that
is.

They can be aligned manually (eyeball) and look fairly good, but I was
thinking there had to be a more accurate way to do it.  I'm currently
using A97, but use 2k and XP on occasion as well.

Thanks in advance!

Greg Smith
weeden1949 at hotmail.com