Hello Everybody,

First time post. Quick question here.

I use Access 97 so this might be too archaic for anybody to answer and if so please let me know.

We are trying to create a directory for all of our associations, where we include the association address(or addresses) and contact information for each prominent member of the association.

When I try to run the report with all the info on a nice sheet, the optional info (i.e. some associations have a billing address and an actual office address, or some have a fax number and some don't) if not available shows up as empty space on the report.

Is there a way that if the field has no information, then the report will not include that field and adjust the other field up accordingly?

Thanks for you help,

Jason

you need to set CanShrink to Yes for the additional fields. check in Help for the CanShrink property.

hth,
al