align text box data to the bottom of the box

G

Guest

I have a tabular report; I want the text in the text boxes to align to the
bottom of the box. Right now it's aligning to the top of the box and I can't
figure out how to change it. I can only find left, right, center and
general. Any ideas?
 
M

Marshall Barton

S. H. Drew said:
I have a tabular report; I want the text in the text boxes to align to the
bottom of the box. Right now it's aligning to the top of the box and I can't
figure out how to change it. I can only find left, right, center and
general. Any ideas?


There's nothing easy. Access only has the horizontal
alignment settings, there is no vertical alignment property.

There might be some rather tricky things you could do, but
they would be highly dependent on the situation in your
report. For example, you could just place the text box
lower in the section's design, but then you might be using
CanGrow on another text box and don't know where the bottom
will be. Another complication is that you are not using
CanGrow, but the other text box is multi-line and you need
them all to have the same size border. Or maybe you do have
CanGrow and also need the borders to have the same height.
 
S

Stephen Lebans

I have a solution here Marsh:
http://www.lebans.com/verticaljustification.htm
VerticalJustificationA2K.zip is a database containing a function to
allow for vertical centering of the contents of a Label or TextBox
control. Works with both Forms and Reports.

The OP would just need to change one line of code to change it from
Vertical Center to Bottom alignment. I'm sure I have posted the mod here
before. A search on GoogleGroups shoudl find it.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top