|
Subject:
|
Report Formatting
|
|
Posted By:
|
echovue
|
Post Date:
|
10/9/2006 12:39:55 AM
|
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
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
10/10/2006 1:37:27 PM
|
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
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
10/10/2006 1:45:27 PM
|
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
|
|
Reply By:
|
echovue
|
Reply Date:
|
10/10/2006 1:48:13 PM
|
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
|
