Entering a line-break in a Label from VB

  • Thread starter Jerry Mc Cauley
  • Start date
J

Jerry Mc Cauley

Hi folks,

I was tring to make a multiline label in a report. I wanted to seperate the
last line (from the one before) with an extra blank line. I used the
following:
label = label &" bla bla bla" & chr$(10)
label = label & "Email: " & txt_email

What I am getting behind the bla bla bla is a little square and then email
appears right after that.

What am I doing worng?

Thanks
 
B

Brendan Reynolds

Try this ...

label = label &" bla bla bla" & Chr$(13) & Chr$(10)
label = label & "Email: " & txt_email

Or, in VBA code (not in queries and expressions) use the intrinsic constant
vbCrLf ...

label = label &" bla bla bla" & vbCrLf
label = label & "Email: " & txt_email
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement help 0
Display text based on date query 0
excel macro mail send 11
How to print labels from excel 1
Unique Number in Email Subject Line 2
Need page break in a large label in a GroupFooter 3
Remove New Page From Labels 0
MS Access 2007 Dot Matrix Label Printing 0

Top