Formating a Carriage Return into text 1

[Krystoff]

Hello all,

I want to have a piece of text that will look something similar to this:

Hello,

This is a text message.

Thank you.

I am calling this text from a function and my code looks something like this.

Test = "Hello, This is a text message. Thank You"

However, when I call it into the report, I want the carriage return to be in there. I tried looking for formating but I came up with nothing. I am sure this is an easy thing to do, I just don't know how.

Any help is appreciated.

Chris

 

[JeremyNYC]

Test = "Hello," & vbcrlf & vbcrlf & "This is a text message." & vbcrlf & vbcrlf & "Thank You"

Should do the trick. Stand for something like Visual Basic Carriage Return Line Feed.

It has to be outside the quotes.

Hope this helps.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[Krystoff]

Thanks again Jeremy!

You seem to help me a lot!

Chris