Gridlines that can grow

[jjarman]

I have 10 fields in a report, all with thin solid lines around each field to form a grid (similar to an Excel spreadsheet).
Most of the fields will never grow as the data is something simple (date, yes/no etc), however a couple fields are allowed to grow depending on how much text is in them.
The fields are able to "grow" however the "grid" loses it's formating when one fields grows and the others stay the same. Is there an easy solution to this?
I have set all the fields to grow, didn't work. I though maybe by grouping all the field together they would be forced to grow to the largest field but there doesn't seem to be an option for this? Any ideas?

 

[PaulO]

Rather than GRIDS, could you instead draw/introduce LINES between the fields. These shouldn't get distorted.

Alternatively, don't allow fields to 'grow'. Rather, set comfortable widths for all fields.

 

[AccessMSSQL]

You can use the Line method in your report.

http://support.microsoft.com/kb/170838

I have used this successfully but you will have to fidget with it to get the lines exactly where you want them to be.

The other thing you can try if you don't care that you have vertical grid lines is just draw a horizontal line and place it at the very bottom of the detail section below your fields. Remove all borders from the fields in your report. The line will move down as the detail section expands.

 

[Lobster1071]

I know this is an old thread, and this resolved my problem except for one small issue. I'm wondering if anyone can point me in a direction that has a better solution.

I am using these varying height vertical lines in a subreport in the details section of the main report. The problem I have is that for some reason on the very LAST record of the subreport, the height of the row is higher than the rest of the rows, and the line doesn't draw all the way to the bottom of the border around the subreport.

I've tried removing the page headers and report headers in the subreport.
I've tried making the details section of the main report a very small height.
I've tried removing the subreport border entirely, and just use horizontal lines in the details section of the subreport, but the vertical line either draws PAST the horizontal line, or is too short.

I CAN get it to work, but it just doesn't look perfect enough for my purposes. It's a simple subreport with 3 fields, but ONE of these fields sometimes has more data in it that makes it print on two lines instead of one. It would be perfect if I could just make the other two fields GROW with the one that does grow. Then I can just put borders around each text box and be done with it.

I've also tried making the heights of the two other fields equal to the one that grows, but I get an error that I can't do that during the formatting of the report, or something like that.

Anyone with a more elegant solution to make 2 fields grow along with the one that does?

Thanks.

 

[Lobster1071]

For those interested, I found a really nice solution at the link below, which is to make a Tabular layout of the fields. That way all fields grow if only one of them does. http://stackoverflow.com/questions/...property-needs-to-effect-neighboring-controls

HOWEVER, there is still a small problem with this solution. Even when you set the padding between the fields to zero, it still creates a very tiny gap between the fields on the vertical lines. Even if I enter the left, or width values manually, they will not match up (there always seems to be a 0.0104 gap between the fields which creates a double line). I have no idea how to fix this, as others seem to be having the problem with no solution found found. The exact issue can be found here. http://answers.microsoft.com/en-us/...-spacing/a29f2388-6e4d-e011-8dfc-68b599b31bf5