How do I lose empty address fields in a report?

[jabberwokiuk]

I have a report producing invoices. I would like to prevent empty date fields from producing gaps in the customer address - a bit like the ignore blanks command in Words mailmerge.

My first thought was to create some code that copies the address fields into an array then sorts through the array removing the empty fields then placing the results into the appropriate text boxes on the report. However I cannot get the array to populate from the required address fields. I just keep getting a the runtime error. How do I access the data in the querry fields that drive the report?

Am I just making this way over complicated? Any help would be appreciated.

Cheers

 

[richard luft]

from what I remember, all you have to do is set 'can shrink' property of report text box to 'true' and text box will not appear on report. Report section should allso be set to Can shrink=true.
Hope this helps
richard