G
Guest
I'm using the following expression in one field and have the Can Shrink
property set to yes, however I'm still getting blank lines if one or more of
the expressions is null. I'm using the expression in a memo field, is that
the problem?
=([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,
property set to yes, however I'm still getting blank lines if one or more of
the expressions is null. I'm using the expression in a memo field, is that
the problem?
=([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,