email new line

[Gismo]

Hi,

what is the vba to force to a new line when i use emaildatabaseobject message text with multiple criteria?
i tried using <VB> as well as & "vbCrLf' &

 

[pbaldy]

Try

"text here" & vbCrLf & "more text here"

 

[Gismo]

Try

"text here" & vbCrLf & "more text here"

i used it as you suggest but access keeps putting [] around cbcrlf

 

[Isaac]

You aren't by chance talking about a code line continuation character are you? If so it's a space, then an underscore, then press Enter. I think Paul got it but just in case, when you said "multiple criteria" it made me think of a long line of code.

 

[Isaac]

If this is in a query, you may have better luck using chr(10) & chr(13)

 

[Gismo]

If this is in a query, you may have better luck using chr(10) & chr(13)

i am using macro builder

 

[Isaac]

Ahh. The one thing I didn't guess having almost never used macros.
Try chr(10) & chr(13)

 

[Gismo]

If this is in a query, you may have better luck using chr(10) & chr(13)

but yes, you suggestion works perfect, thank you

 

[Isaac]

We were glad to help. And I learned something new about Macros today ....

 

[pbaldy]

what is the vba

This threw me off.

 

[Isaac]

Me too