Vertically Aligning Text in Access Reports 1

[corycrum]

Hi,

I'm trying to vertically align text in an Access report similar to vertically aligning text in Excel (top, middle, or bottom).

This solution must be dynamic because different rows will be different heights. I have the "can grow" property set to "yes". So, one row may be 3 lines tall, the next 2 lines tall, and another 6 lines tall. So, I need all columns in that row to automatically adjust so that they are vertically aligned to the center.

If anyone can help I would really appreciate it!

Cory

 

[maxhugen]

Cory, I'm not sure if this is the best answer... in the detail section, in OnFormat event, use the height property of the control that 'grows' the most, to set the height of the other controls that you also want to 'grow'.

HTH

Max Hugen
Australia

 

[dhookom]

With questions like this, always search Stephen Lebans' site. I found this link that might help

http://www.lebans.com/verticaljustification.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]