Change Height of Box to height of textBox

[oxicottin]

Hello, I have been fiddleing around with this all day and cant seem to get it to work correctly. I have a report that has various controls throughout the detail section and one text box in that section can grow. Well in this section with the text box that can grow there is a box around that section and this box is slightly larger in height so it boxes in all the text boxes/controls in that section. I need the box (bxSpecialInstructions) to grow in height when the text box (txtSpecialInstructions) grows BUT always stay slightly taller. I tried the VBA below and it works but the Box isn't constant in its height but always stays taller. How can I get it to work properly? Thanks!

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
 Me.bxSpecialInstructions.Height = Me.txtSpecialInstructions.Height + 12 * Len(Me.txtSpecialInstructions)
End Sub

[June7]

What do you mean by 'constant in its height'? You mean the box remains the height for all records as set by the first record? This is expected because changing the properties of a control changes for all instances of the control.

[oxicottin]

In my attachment it does show you exactly what im trying to achieve... What im looking to do is have the box (bxSpecialInstructions) slightly larger in height than the textbox (txtSpecialInstructions) and as the textbox grows in height the Box does also in height but yet still stays that slightly larger aspect.

[June7]

I explained in my previous post why the height does not change for each record. I don't know any method to dynamically adjust control properties for each record in a continuous record output. I have tried and it just doesn't work.

[oxicottin]

What do you mean continuous record output? This is a report just like the example I attached in my inital post. Please have a look because I think were on two different pages.... Thanks!

[June7]

That report is what I mean by 'continuous'. Multiple records displayed in the detail section. As opposed to opening the report filtered to just one record.

Changing the box design property will cause it to display with that setting for ALL records. The event runs just once so that property is set based on the first record and stays that way for the remainder.

[oxicottin]

Ok I figured a work around then without VBA. Change the margins ect and it works great.

[June7]

Glad you found a solution. It is definitely working although I can't see why. What do you mean by 'change the margins etc'?