Suppressing Empty Fields

[Transentient]

I have written a procedure in my database(access97) which enables me to select specific contacts and produce a mailing label. Placing the label anywhere I require on a sheet, allowing for used label fields. This works find.

The label document is a report, what I need to do is emulate the suppress empty lines feature of the MSword Mailmerge.

I am looking to suppress/remove any field on the report which maybe empty such that is the mailing address is a short address there are no Gaps, but there are sufficient fields for longer addresses.

My addressing structure is as follows, each is a seperate field on the report

Company Name
Address1
Address2
Address3
Address4
Town
County
Country
PostCode

Any help would be greatly appreciated

Regards

 

[KenHigg]

I would do something like the following in the underlying query:

MyNewAddress: Address1 & iif(isnull(Address2), "", vbcrlf & Address2) & etc

The put it in a text box control that can grow.

???
ken