Concatenation and IIF statements in report

[bjsbrown]

yes, it's in groupheader 1. Finally got to run but still blank line in address.
Private Sub GroupHeader1_Print(Cancel As Integer, PrintCount As Integer)
If Len(MemAdd2 & "") = 0 Then
MemAdd2.Visible = False
Else
MemAdd2.Visible = True
End If
End Sub

[RuralGuy]

Have you set the CanShrink property of the control *and* the Section to YES?

[bjsbrown]

Yes groupheader 1 is correct. Finally but to run but empty line in address still there.

Private Sub GroupHeader1_Print(Cancel As Integer, PrintCount As Integer)
If Len(MemAdd2 & "") = 0 Then
MemAdd2.Visible = False
Else
MemAdd2.Visible = True
End If
End Sub

[bjsbrown]

BINGO. Thanks a lot for your help. One more question. I'm still learning on using some of the code features. Is all the code used in different controls for the same db entered on the same page. In other words, is the same page supposed to open each time the (...) is used to enter.

[RuralGuy]

Is there anything else on the line with the 2nd address? Change the name of the MemAdd2 control to txtMemAdd2 and then reference the control in the code.

[RuralGuy]

BINGO. Thanks a lot for your help. One more question. I'm still learning on using some of the code features. Is all the code used in different controls for the same db entered on the same page. In other words, is the same page supposed to open each time the (...) is used to enter.

I think the answer to this question is YES. Each Form/Report has its own Class Module. Are you ready to follow the link in my sig to mark this thread as Solved?