 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / December 2007Same Height
Hi Groupies All of my text boxes in the detail section are set to Can Grow. My problem is that if one of the boxes needs to grow, I need the other text boxes to grow to the same size. The box that usually needs to grow is called strName, so I would like all of the other boxes to be the same height as strName when the detail prints. I am testing this with one of the other boxes and at the moment, I have the following code, but nothing is changing: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Package.Height = Me.strName.Height End Sub Some insight into the problem would be greatly appreciated.  SignatureThanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! As you may have found out, this won't work. The grown height of the text box can't be determined until the On Print event. At that point it is too late to set the height of other controls. The common solution is to remove the borders from all text boxes and use code in the On Print event to find the tallest text box. Then use the Line method of the report to draw rectangles around all text boxes. This question get answered several times per month so you should be able to Access reports Me.Line On Print Hookom If you don't find some code, let us know. SignatureDuane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm > Hi Groupies > [quoted text clipped - 14 lines] > > Some insight into the problem would be greatly appreciated. >All of my text boxes in the detail section are set to Can Grow. My problem >is that if one of the boxes needs to grow, I need the other text boxes to [quoted text clipped - 12 lines] > >Some insight into the problem would be greatly appreciated. Check Print Lines at www.lebans.com SignatureMarsh MVP [MS Access] >>All of my text boxes in the detail section are set to Can Grow. My problem >>is that if one of the boxes needs to grow, I need the other text boxes to [quoted text clipped - 17 lines] > > Check Print Lines at www.lebans.com Duane and Marshall, thank you very much. I sort of suspected this would be the case but I guess I was hoping for something a little easier. SignatureThanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.