Carriage Return in Report - Textbox

  • Thread starter Thread starter Benjamin Z. Gregorian
  • Start date Start date
B

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)
 
Benjamin said:
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]
Click to expand...
 
Rick said:
Benjamin said:
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
Click to expand...
Click to expand...
 
Benjamin said:
Rick said:
Benjamin said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Rick said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top