Can grow fields with line divider

[Newbie456]

I have a report in which there are lines between the fields and a horizontal line between each record. The vertical lines work fine, but the horizontal line (which I drew with the line tool) doesn't move down when fields grow - meaning sometimes it's in the middle of a field.

The weird part is, it does for my second field (a text field), but not for the last field (a memo field). I want the line to simply divide records.

Thanks for any input!

 

[dhookom]

The horizontal line Top property must be greater than the Top plus Height properties of all controls above it. This makes sure the line is below the Can Grow controls so that it will be pushed down.

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]

 

[Newbie456]

An easy fix! Worked great, thanks!

 

[StrikeEagleII]

Were you able to get the vertical lines to resize? if so, how? I'm trying to do the same thing and originally just had the borders of the text boxes set to solid (to give it a spreadsheet grid feel). This worked as long as none of the fields "grew". When that happened, only the border of the text box that grew would grow...all the other text boxes in the record would remain the same size creating gaps in the border...is there a way to get around that?
Thanks!

Jason

 

[dhookom]

If you are using "can grow" text boxes, you will need code in the On Print event of the report section. The code would loop through the controls to find the tallest and then use the Line method to draw boxes.

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]

 

[Newbie456]

Yes, that's exactly what I did. Do a keyword search for old threads on vertical lines which can grow if you need more details. I found the answer on here somewhere.

 

[StrikeEagleII]

Found it. Done it. Works great. Thanks!!