Newline in String?

[Jean-Pierre Bergamin]

Hello everybody

I really can't find out howto add a newline into a simple string. I want to
do something like:

=IIf([req_description]<>"";"Description: " & [req_description];"")

....but with a newline after "Description:". How do I enter a newline?
Thanks for your help

Jean-Pierre

[Allen Browne]

Try:
=IIf(IsNull([req_description]), Null, "Description:" & Chr(13) & Chr(10) &
[req_description])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jean-Pierre Bergamin" <ja***@se-community.com> wrote in message
news:42**********************@news.sunrise.ch...

Hello everybody

I really can't find out howto add a newline into a simple string. I want
to
do something like:

=IIf([req_description]<>"";"Description: " & [req_description];"")

...but with a newline after "Description:". How do I enter a newline?
Thanks for your help

Jean-Pierre

[Trevor Best]

Allen Browne wrote:

Try:
=IIf(IsNull([req_description]), Null, "Description:" & Chr(13) & Chr(10) &
[req_description])

How about
="Description:" + vbCRLF + [req_description]

As (AFAIK) the + concatenator would render the whole expression as null
if req_description was null.

--
[Oo=w=oO]

[Allen Browne]

Yes, that's fine, except the line starting with = made me wonder if this is
the Control Source of a text box? If so the constant (vbCrLf) is not
available.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Trevor Best" <no****@besty.org.uk> wrote in message
news:42***********************@news.zen.co.uk...

Allen Browne wrote:

Try:
=IIf(IsNull([req_description]), Null, "Description:" & Chr(13) & Chr(10)
& [req_description])

How about
="Description:" + vbCRLF + [req_description]

As (AFAIK) the + concatenator would render the whole expression as null if
req_description was null.

--
[Oo=w=oO]