vertical align an Access report's textbox

[rayc]

I have a report with a large textbox. The text box has enough space to display about three lines of text. However, when there is just one line of text to display it displays on the first line. How do I center it vertically? In other words, one line of text should appear on line 2. I.E. in the middle.


There is no etxtbox property that does this.

Thanks!

[StepUP]

You would have to use a fixed width font (such as Courier) and calculate the number of characters that fit on 1 line.

Add some code on the Format event for the detail line of the report and check if the number of characters in the text box are less than or equal to the one line maximum. If so, add a vbCrLf before the beginning of the text.

[rayc]

Unfortunately, I cannot change the font, my client does not want me to. It's for an important "presentation" report. Is it safe to assume that Access does not provide a "vertical justify center" button. It has a horizontal justiry center button in the toolbox. Why not the other? Strange.