Mailing Labels and Blank Lines

[wattride]

Invoice problem

I have read the many posts in regard to trying to eliminate extra spaces created by blank lines, e.g. Address Line 1 but no Address Line 2. The elegant solution of using the Function AddressBlock as described in MS KB Article 95390 works perfectly for me for the one address block in my invoice for the Billing Address. But I am unable to get 2 blocks to work together. Can 2 blocks work side by side in an invoice report, one block for the Billing Address the other for the Shipping Address? Has anyone else solved this?

Thank you.

Bill

 

[llkhoutx]

Concancenate your addresses skipping blank fields.

 

[wattride]

OK...that worked.

Now, is there any technique for Bolding the First Line, i.e. the Customer/Client Name?

Thanks.

Bill

 

[llkhoutx]

Yes, but it depends on the fields comprising the name.

Assuming the following fields:

sFristName
sMiddleName/Initial
sLastName
sStreeAddress1
sStreeAddress2
sCity
sState
sZip


You have to test whether or not each field is Null before concantenating.

sConcantenatedName = ""
if sFirstName & "" <> "" then sConcantenatedName = sFirstName & " "
if sMIddleNameInitial & "" <> "" then _
sConcantenatedName = sConcantenatedName & sMiddleeNameInitial & " "
if sLastname & "" <> "" then _
sConcantenatedName = sConcantenatedName & sLastname & vbCRLF

etc.