Text Box Middle Alignment

[vorngsarorn]

Dear All,



Hi everyone,


I'm working on an Access report and I'm trying to achieve the same text formatting as I can in Excel. In Excel, I can easily wrap text and center it vertically within a cell. However, I can't seem to find a way to both wrap text and center text vertically in a text box within Access reports.


Is there a way to accomplish this in Access, or is there a workaround that would achieve a similar result?


Any advice would be greatly appreciated!


Thanks,

[Micron]

You could try setting the textbox Can Grow property to yes, then it should word wrap. However, I don't think there is a way to center vertically; not even if you increase the Top and Bottom Padding values for the textbox.

EDIT -

I don't think there is a way to center vertically

I meant by setting control properties since IIRC, there is no option to center text vertically. Maybe by using code to determine the height of every textbox on a row, choose the largest (assuming that is because it expanded) then doing some math to change the position of the rest of them, relative to the position of the expanded one. Too much work for zero payback, even if it works - unless you find some ready to use code.

[vorngsarorn]

Thank you and I have try for Can Grow and Shrink property to "YES" also play the Top margin but it's still no luck. As you may say too much work and VBA code might be along with

[Micron]

Have not investigated this but others have indicated it works
http://www.lebans.com/verticaljustification.htm

[vorngsarorn]

Thank anyway I will try. Very much appreciated to your kind help.

[Micron]

You're welcome, and good luck!

[Welshgasman]

Crossposted https://www.access-programmers.co.uk...gnment.330506/