Makes dividing lines grow?

[acepayne]

Hello,

I have placed some vertical lines in the detail section of a report, to act as dividing lines between groups of related columns.

A couple of the text fields have their CanGrow property set to true, as sometimes they are longer than average, and need to be seen.

Is there a way to have the dividing lines grow with them? It looks fairly hiedous when the row grows, leaving gaps in the dividing lines.

Please let me know if there is a way to do something like this!

Thanks,
Gord

 

[Rich@ITTC]

Hi Gord

Yes lines can grow, but ... it is not all that straight-forward to work out how!

Unfortunately lines do not have a "Can Grow" property.

You can have a border around your text boxes on a report and this (the text box) can be set to can grow and the border will naturally grow too.

Apart from that you have to get into VBA coding to achieve what you want.

See this link for an article on the topic:
http://www.smartaccessnewsletter.com/sa/samain.nsf/0/DDADC434363B795B85256A13001CE55F

The March 2001 article deals with this problem (though it is quite complex and you need to be a subscriber to Smart Access to view it).

HTH

Rich Gorvin



[This message has been edited by Rich@ITTC (edited 09-27-2001).]

 

[acepayne]

Hey, thanks Rich. I signed up for SmartAccess, and read your article. Good stuff!

I had been playing around with the text boxes and their borders, but it wasn't working out the way I liked.

I think your solution will work just great. It is a bit more work, but I'm a bit stubborn about these things, so it will be worth it.

Thanks a lot,
Gord