Concatenate shows "square boxes" unknown characters at paragraph e

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Concatenate shows "square boxes" unknown characters at paragraph end

Hi, I was wondering if anyone can tell me why I am getting the funky
unknown character "square boxes" at the end of my concatenated paragraphs. I
get the unknown characters at the end of the last line and it does not matter
whether there are 2, 3, or more lines in the paragraph.

My control for the text box is this:

=IIf(IsNull([REV_B]),"",[REV_B] & (Chr(13) & Chr(10)+[REV_C]) & (Chr(13) &
Chr(10)+[REV_D]))

Basically, it says if REV_B is null then don't display anything else, but if
it has data then display it, do a CR and LF to the next line, and so on...

Then, in my query which the report is based on, my fields are coded with this:

REV_B: IIf(([USER_3])="","","REV.B QUOTE: " & Trim([USER_3]))

It is the same for REV_B, REV_C, and REV_D fields.

Thanks for your help!
 
Try:

=IIf(IsNull([REV_B]), Null,
[REV_B] & (Chr(13)+Chr(10)+[REV_C]) & (Chr(13)+Chr(10)+[REV_D]))

The way your concatenation operators were specified, you could get a couple
of Chr(13) characters without the Chr(10), which could display as square
boxes.
 
Thanks Allen. Worked like a charm! Thanks for your quick response.


Allen Browne said:
Try:

=IIf(IsNull([REV_B]), Null,
[REV_B] & (Chr(13)+Chr(10)+[REV_C]) & (Chr(13)+Chr(10)+[REV_D]))

The way your concatenation operators were specified, you could get a couple
of Chr(13) characters without the Chr(10), which could display as square
boxes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

laknight said:
Concatenate shows "square boxes" unknown characters at paragraph end

Hi, I was wondering if anyone can tell me why I am getting the funky
unknown character "square boxes" at the end of my concatenated paragraphs.
I
get the unknown characters at the end of the last line and it does not
matter
whether there are 2, 3, or more lines in the paragraph.

My control for the text box is this:

=IIf(IsNull([REV_B]),"",[REV_B] & (Chr(13) & Chr(10)+[REV_C]) & (Chr(13) &
Chr(10)+[REV_D]))

Basically, it says if REV_B is null then don't display anything else, but
if
it has data then display it, do a CR and LF to the next line, and so on...

Then, in my query which the report is based on, my fields are coded with
this:

REV_B: IIf(([USER_3])="","","REV.B QUOTE: " & Trim([USER_3]))

It is the same for REV_B, REV_C, and REV_D fields.

Thanks for your help!
Click to expand...
Click to expand...
 
Could it be the first ( before the Chr(13). I tried the same but without the
( before the Chr(13) and got a clean result.
 
Back
Top