Delete Field if Empty?

[bpowers2010]

Hi,



I am creating a database with basic address information. There are 3 fields: Address 1, Address 2 and Address 3 for Street, Supplementary and Room numbers etc. I am generating a report and I was wondering if there is a way to essentially delete a field if there is no text in it. Here is an example. Two different people:

Name: John Doe
Address 1: 123 Sunnyvale Road
Address 2:
Address 3:
City/State/Zip: Brunswick, MO 63123

and

Name: Jane Doe
Address 1: XYZ Associates
Address 2: 16 West 42nd Street
Address 3: 9th Floor, Suite 200
City/State/Zip: Brunswick, MO 63123


If I set up the report to have all those fields I get the following entries:

John Doe
123 Sunnyvale Road


Brunswick, MO 63123


and

Jane Doe
XYZ Associates
16 West 42nd Street
9th Floor, Suite 200
Brunswick, MO 63123

So, it works for Jane (since she fills all fields) but not John (since he lacks info for 2 and 3). Is there a way to essentially delete unused fields so they wont take up space in the report. So john shows up like

John Doe
123 Sunnyvale Road
Brunswick, MO 63123

Thanks so much

[maximus]

This is a link to an earlier post that I had posted a code to delete Fields that are empty. I think this will be helpful for you.

https://www.accessforums.net/program...able-5608.html