Hi folks
In my form there's an email button. This pulls through certain form data to the email combined with generic text.
I have a block of controls on my form which are comments boxes. I need the email to pull through any comments in these boxes unless the box is empty - null or "".
I've tried the following:
As the above no doubt demonstrates I'm not big on VB!!
Thanks for any help received and time spent.
In my form there's an email button. This pulls through certain form data to the email combined with generic text.
I have a block of controls on my form which are comments boxes. I need the email to pull through any comments in these boxes unless the box is empty - null or "".
I've tried the following:
Code:
stDocBody = stDocBody & Nz(Me.TandEQ1aC, Me.TandEQ1aC.Visible = False) & vbCrLf
stDocBody = stDocBody & Nz(Me.TandEQ1bC, Me.TandEQ1bC.Visible = False) & vbCrLf
stDocBody = stDocBody & Nz(Me.TandEQ2aC, Me.TandEQ2aC.Visible = False) & vbCrLf
As the above no doubt demonstrates I'm not big on VB!!
Thanks for any help received and time spent.