Carriage Returns... Avoid Blank Space

D

Dee

I have the formula below that gives me basically what I want, only I end up
with blank space. First I'll give you the code and then the example of how
it shows up. I appreciate any help anyone can give - hopefully tonight :).

=IIf(IsNull([firstname]),"","" & [firstname]) & IIf(IsNull([Last Name]),"","
" & [Last Name]) & Chr(13) & Chr(10) & [CHCompany] &
IIf(IsNull([Division]),""," " & [Division]) & Chr(13) & Chr(10) &
IIf(IsNull([Address]),"","" & Chr(13) & Chr(10) & [Address]) &
IIf(IsNull([Address2]),"","" & Chr(13) & Chr(10) & [Address2]) & Chr(13) &
Chr(10) & IIf(IsNull([City]),"","" & [City]) & IIf(IsNull([State]),"",", " &
[State]) & IIf(IsNull([Zip]),""," " & [Zip]) & IIf(IsNull([Country]),""," "
& Chr(13) & Chr(10) & [Country]) & Chr(13) & Chr(10) &
IIf(IsNull([Phone]),"","Phone: " & [phone]) & Chr(13) & Chr(10) &
IIf(IsNull([Fax]),"","Fax: " & [fax]) & Chr(13) & Chr(10) &
IIf(IsNull([mobile]),"","Mobile: " & [mobile]) & Chr(13) & Chr(10) &
IIf(IsNull([pager]),"","Pager: " & [pager]) & Chr(13) & Chr(10) &
IIf(IsNull([homephone]),"","Home Phone: " & [homephone]) & Chr(13) &
Chr(10) & IIf(IsNull((e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing Empty Line 5
Address box with IIf Statement 7
Carriage Return in calculated field 7
VB code in Report On Format 1
Field in Query Expression Displaying Number on Report 5
Why am I still getting data??? 3
Address Label Problem 3
Same expression gets different results in Report and Query 1

Top