Carriage Return in Report - Textbox

[Benjamin Z. Gregorian]

Hi there,

as I tried to put two strings together with the following code as a
control source to a textbox in a report I got not the intended result.

CODE:
=(e-mail address removed)

 

[Rick Brandt]

Hi there,

as I tried to put two strings together with the following code as a
control source to a textbox in a report I got not the intended result.

CODE:
=+chr(13)+[hp][/QUOTE]

Access requires both a Carriage Return and a Line Feed (in that order). Also it
is better to use "&" for concatenation as "+" propogates Nulls (unless that was
your intention).

=[email] & chr(13) & Chr(10) & [hp]

 

[Benjamin Z. Gregorian]

Hi there,

as I tried to put two strings together with the following code as a
control source to a textbox in a report I got not the intended result.

CODE:
=+chr(13)+[hp][/QUOTE]


Access requires both a Carriage Return and a Line Feed (in that order). Also it
is better to use "&" for concatenation as "+" propogates Nulls (unless that was
your intention).

=[email] & chr(13) & Chr(10) & [hp]
[/QUOTE]
Unfortunately in my case it shows not the expected result but now I see
two caros instead of one.

Benjamin

 

[Rick Brandt]

Hi there,

as I tried to put two strings together with the following code as a
control source to a textbox in a report I got not the intended
result.

CODE:
=+chr(13)+[hp][/QUOTE]


Access requires both a Carriage Return and a Line Feed (in that
order). Also it is better to use "&" for concatenation as "+"
propogates Nulls (unless that was your intention).

=[email] & chr(13) & Chr(10) & [hp]
[/QUOTE]
Unfortunately in my case it shows not the expected result but now I
see two caros instead of one.

Benjamin[/QUOTE]

Are you positive you did the Chr(13) first? It will not work if Chr(10) is
first.

 

[Benjamin Z. Gregorian]

Access requires both a Carriage Return and a Line Feed (in that
order). Also it is better to use "&" for concatenation as "+"
propogates Nulls (unless that was your intention).

= & chr(13) & Chr(10) & [hp]
[/QUOTE]

Unfortunately in my case it shows not the expected result but now I
see two caros instead of one.

Benjamin[/QUOTE]


Are you positive you did the Chr(13) first? It will not work if Chr(10) is
first.
[/QUOTE]

You were right! Thank you

Benjamin