Center text in textbox (top, middle,bottom)

[nemesisswe]

Is there no way to center the text vertically in a text box? (access 2016)


.. or have I missed something..?

[isladogs]

You can centre align text from the property sheet
However its not possible to rotate text in a textbox - it is possible in a label

[nemesisswe]

@isladogs that's only horizontally..

[davegri]

You can set bottom margins in textboxes, see properties.

[nemesisswe]

You can set bottom margins in textboxes, see properties.

Yeah, but that's not "middle", that won't change depending on lines in the box..

[davegri]

Yeah, but that's not "middle", that won't change depending on lines in the box..

Ah so, hadn't considered multi-line data.

[isladogs]

@isladogs that's only horizontally..

Yes I'm aware of that ... your requirements were not at all clear. That's why I asked about text rotation
Doing this is easy....


But moving the text so it is aligned centrally in a vertical direction is much harder.
It will probably require the use of APTs and be a lot of work
If its that important to you, I suggest you look at Stephen Lebans' website: Lebans.com
Although it was written 20+ years ago, much of its content has never been improved since by anyone else

Good luck

[Micron]

I don't suppose you can alter the height of the textbox to suit the number of lines, padding and font sizes?

[kd2017]

Could you just come up with an estimate of number of chars per line to estimate number of lines then use that to tweak the textbox's margin to get a faux vertical centering? Not perfect but might get you close enough?

[davegri]

If the lines are short and don't wrap, you could get a count of lines by counting the vbCRLFs in the string.

[nemesisswe]

It's either 1 or two lines always...