Optional Field Question

[ntxsoccer]

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

 

[pcs]

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

hth,
al