email new line (1 Viewer)

Gismo

Registered User.
Local time
Today, 20:27
Joined
Jun 12, 2017
Messages
1,298
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

Wino Moderator
Staff member
Local time
Today, 11:27
Joined
Aug 30, 2003
Messages
36,118
Try

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

Gismo

Registered User.
Local time
Today, 20:27
Joined
Jun 12, 2017
Messages
1,298
Try

"text here" & vbCrLf & "more text here"
i used it as you suggest but access keeps putting [] around cbcrlf

1593618109614.png
 

Isaac

Lifelong Learner
Local time
Today, 11:27
Joined
Mar 14, 2017
Messages
8,738
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

Lifelong Learner
Local time
Today, 11:27
Joined
Mar 14, 2017
Messages
8,738
If this is in a query, you may have better luck using chr(10) & chr(13)
 

Isaac

Lifelong Learner
Local time
Today, 11:27
Joined
Mar 14, 2017
Messages
8,738
Ahh. The one thing I didn't guess having almost never used macros.
Try chr(10) & chr(13)
 

Isaac

Lifelong Learner
Local time
Today, 11:27
Joined
Mar 14, 2017
Messages
8,738
We were glad to help. And I learned something new about Macros today ....
 

Users who are viewing this thread

Top Bottom