Align Page Header Text to Bottom

  • Thread starter Thread starter ArneGolf
  • Start date Start date
A

ArneGolf

Is there a way to have the page headers in a report to align to the bottom
instead of the top. Some of my names are longer than others so they wrap but
I would like the vertical alignment to be at the bottom instead of the top.
 
Arne,
Usually... it's best to respond to previously posted questions... before
starting a new one.
On 2/14/2010 you posted the question "DLookup Different Values"
Please see my response to that post, and let us know if that helped or
not.

Regarding this post, could you try to show a sample of what you're
trying to
do? "Here's what I have vs. this is what I'd like to see." I realize that
it might be
tough in text only, but I think it will help us understand what your trying
to
accomplish.
 
I believe what you are saying is that you have a control that is two lines
high and you want the short text to print in the bottom of the control.

For example, let's say you have a control to contain a person's name and you
want an effect like I attempt to depict in the crude "sketches" below.
----- Short Text ------
+ <<Blank>>
+ John Spencer
-----------------------

----- Longer Text -----
+ Ricard James
+ Oliver, Jr
-----------------------

In Excel, you would be setting the VERTICAL alignment of a cell to Bottom
versus setting it to Top. I don't know of a way to accomplish this in Access.

It could probably be done with some VBA and measuring the physical length of
the text based on the font and font size, but I don't know how to do this. I
would check out www.lebans.com and see if Stephen Lebans developed a solution
for this before he "retired" from all thing Access.

Specifically look at at least these two. They might give you an idea of how
to solve your challenge.
http://www.lebans.com/baseline.htm
http://www.lebans.com/verticaljustification.htm

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
It currently looks lik this:
Family Junior Junior
Membership Membership Membership
In School Out of
District School
District

I want it to look like:
Junior
Junior Membership
Membership Out of
Family In School School
Membership District District
 
Back
Top