Blank lines in report

[Guest]

I have the following expression in a memo field. The problem is, when some
of the fields are null, the form prints with blank lines between each
expression. I've tried using the can shrink property, but it's not working.
What am I doing wrong?

=([RESOLUTION NOTES]) & Chr(13) & Chr(10) & IIf([REPAIR ORDER
SUBMITTED]=True,"REPAIR ORDER SUBMITTED.","") & Chr(13) & Chr(10) & IIf([ars
tag ORDERED]=True,"ARS TAG ISSUED.","") & Chr(13) & Chr(10) & IIf([CREDIT
MEMO SUBMITTED]=True,"CREDIT MEMO SUBMITTED" & " " & [DATE CREDIT
SUBMITTED],"") & Chr(13) & Chr(10) & IIf([DEBIT/CREDIT MEMO
SUBMITTED]=True,"DEBIT MEMO SUBMITTED" & " " & [DATE CREDIT SUBMITTED],"")

Thank you.

 

[Rick B]

You are telling it to feed a line (period). You would need to put each of
those line feeds into an "if" statement and only do them if the following
item contains data.

Can shrink won't work when you use hard returns like this. If each item was
in a separate field (one above the other) then you would be able to simply
use the shrink.

Rick B

 

[John Spencer (MVP)]

You need the Chr(13) & Chr(10) inside the IIF statements. Something like the following.

=([RESOLUTION NOTES]) &
IIf([REPAIR ORDER SUBMITTED]=True, Chr(13) & Chr(10) & "REPAIR ORDER
SUBMITTED.",Null)
& IIf([ars tag ORDERED]=True,Chr(13) & Chr(10) & "ARS TAG ISSUED.", Null)
& IIf([CREDIT MEMO SUBMITTED]=True, Chr(13) & Chr(10) & "CREDIT MEMO SUBMITTED"
& " " & [DATE CREDIT SUBMITTED], Null)
& IIf([DEBIT/CREDIT MEMO SUBMITTED]=True, Chr(13) & Chr(10) & "DEBIT MEMO
SUBMITTED" & " " & [DATE CREDIT SUBMITTED],Null)