How can I center-vertical align a cell in Access 2007 report ?

Discussion:

(too old to reply)

Antonio Torres

2009-08-18 14:06:01 UTC

I am preparing a report with Access 2007, and I would like to vertically
center align the cell. I looked in the help section, but I did not find an
naswer.
Any help?
Thanks

Antonio

KARL DEWEY

2009-08-18 15:08:01 UTC

Permalink

Open report in design view, click on the text box, right click, scroll down
to Properties and select.
Scroll down to Text Align and select Center.
--
Build a little, test a little.

Post by Antonio Torres
I am preparing a report with Access 2007, and I would like to vertically
center align the cell. I looked in the help section, but I did not find an
naswer.
Any help?
Thanks
Antonio

SuzyQ

2009-08-18 15:28:01 UTC

Permalink

I think OP is looking for vertical alignment. Doesn't the align center only
do horizontal alignment?

Post by KARL DEWEY
Open report in design view, click on the text box, right click, scroll down
to Properties and select.
Scroll down to Text Align and select Center.
--
Build a little, test a little.

KARL DEWEY

2009-08-18 17:23:01 UTC

Permalink

You are right, I did not read close. Did not consider anyone asking for
vertical movement.
--
Build a little, test a little.

Post by SuzyQ
I think OP is looking for vertical alignment. Doesn't the align center only
do horizontal alignment?

Stephen Lebans

2009-08-19 03:06:56 UTC

Permalink

See:
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.
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

k***@gmail.com

2019-02-11 14:45:56 UTC

Permalink

it does not work for earlier version of Office
it will show me this error "the field is too long for this control"

thanks
regards
Farzad