MS Access Reports - Omitting Blank Lines 1

[littlehoa]

HELP!!! This should be easy, but doesn't seem to be for me.
I need to create a report containing directory information - names, addresses, phone numbers, cell numbers, email addresses, etc.
Not all records have values in every field.
How can I eliminate the white space left when there is an empty field?
I currently have several fields referenced in one text box - see below.
What I'm getting is no data at all once a null field is encountered. For example:
When the cell2 field is null then nothing else prints after the FirstName2 field.
Sorry for my rustiness with Access report - Thanks in advance!

Current text box syntax:

=IIf(IsNull([FirstName2]),"",RTrim([FirstName2] & Chr(13) & Chr(10)) & IIf(IsNull([Cell2]),"",RTrim([Cell2]) & IIf(IsNull([work2]),""," " & [work2] & Chr(13) & Chr(10)) & IIf(IsNull([Email2]),"",RTrim([Email2] & Chr(13) & Chr(10)) & IIf(IsNull([Child1]),"",[Child1] & IIf(IsNull([Child2]),""," " & [Child2] & Chr(13) & Chr(10)) & IIf(IsNull([Child3]),"",[Child3] & IIf(IsNull([Child4]),""," " & [Child4] & Chr(13) & Chr(10)))))))

 

[nice12345]

hi try posting to the access reports forum

http://www.tek-tips.com/threadminder.cfm?pid=703

you may have better luck