Solved Match the Label height with the text box in a report and print

[Sodslaw]

Searched and found a solution for this issue but for some reason its not working for me.

Code im using...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.LblNotes.Height = Me.Notes.Height
End Sub

Results....

BTW the Text box "can grow"

Any idea why the label isnt growing? thanks in advance.

i just added a msgbox to see the height of both label and txtbox

MsgBox "Notes Height= " & Me.Notes.Height & "  Lbl Height= " & Me.LblNotes.Height

 

[arnelgp]

on report design view, select the textbox and the label.
on ribbon->arrange->stacked.

no need to add code to the format event of the detail section.

 

[Sodslaw]

 

[arnelgp]

 

[Sodslaw]

Same result.
intresingly if i remove the label and add another txtbox and give it a value then it works.
ie

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Lbltxt.value = "NOTES:"
Me.Lbltxt.Height = Me.Notes.Height
End Sub

i think that will do. but its intresting......

 

[Sodslaw]

@arnelgp BTW if i remove the stacked function, then it doesnt work again. So, without knowing to implement the stacked function i wouldnt have solved it ..... many thanks mate, great Job!