Hi Everyone,

Here is the problem... I am putting together a report that has a simple recordset, and displays about 5 fields straight across on the report. I would like to put gridlines around these fields, to define each field/cell.

The data often has fields that are several lines long, and so I have set the Can Grow property to allow them to resize to the length of the data. The problem then is that the gridlines are staggered based on the size of the field.

Is there anyway to set all fields to be the same height, or at the very least, if I were to put in a series of vertical lines, could I in effect dock these to the top and bottom of the detail field, so that they would grow/shrink with the data?

Any suggestions would be appreciated.

Thanks

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

You mean something like

Me.Line1.Height = Me.Textbox1.Height

kind of thing?

You would have to check for the tallest textbox, and then set all your lines to that height. Interesting problem.

Lemme look...


mmcdonal

This took the height of a textbox on one of my reports in twips:

Me.Text9.Height

If you use this, you can check the heights of all of your text boxes, choose the tallest one, and then set the line heights like this:

iHeight = 'tallest line height plus some value.

Me.Line1.Height = iHeight
Me.Line2.Height = iHeight
etc...

Something like that.

Does that help?

mmcdonal

Hi Mike,

Thanks, I found a similar solution in the Access Cookbook last night. Yours actually looks simpler, so I'll try and get it implemented tonight.

Thanks again,

Mike

Mike
EchoVue.com