How to shrink and grow ?

[am_sarath]

Hello

I have few reocrds of variable lenght in my database and I have drawn horizontal and vertical lines in my detail section of the report.I see some blank spaces when I print the report.Could you please help me out how to shrink and grow the lines as per the records.

Thanking in advance.

 

[Rich@ITTC]

Hi am_sarath

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