Create family directory with conditions


A

Angi

I need to create a directory based on certain conditions and I can't
figure out how to get rid of the white space. Hopefully someone can
help me.

Families can choose to have their names, addresses and/or phone
numbers in the directory. If they don't want their names, they're
simply not added. The problem comes when they only want their phone
number and not their address. Is it possible to make the detail grow
or shrink depending on what information is printed? Detail Can Grow
and Can Shrink is set to yes. I've tried using the Print Data only,
but that still doesn't eliminate the white space.

EX:
Family Name
Address
City State Zip
Phone
Family names (subreport)

If the family only wants their name and number, it looks like this:

Family Name
Phone


Family names (subreport)


To get the phone number to replace the address line, I'm using a text
box with
=IIf([DirectoryAddress]=Yes,[Home Address],IIf([DirectoryPhone]=Yes,
[HomePhone#],""))

Can this be done OR is there a better way to do it that I'm missing?
 
Ad

Advertisements

A

Angi

I need to create a directory based on certain conditions and I can't
figure out how to get rid of the white space.  Hopefully someone can
help me.

Families can choose to have their names, addresses and/or phone
numbers in the directory.  If they don't want their names, they're
simply not added.  The problem comes when they only want their phone
number and not their address.  Is it possible to make the detail grow
or shrink depending on what information is printed?  Detail Can Grow
and Can Shrink is set to yes.  I've tried using the Print Data only,
but that still doesn't eliminate the white space.

EX:
Family Name
Address
City State Zip
Phone
Family names (subreport)

If the family only wants their name and number, it looks like this:

Family Name
Phone

Family names (subreport)

To get the phone number to replace the address line, I'm using a text
box with
=IIf([DirectoryAddress]=Yes,[Home Address],IIf([DirectoryPhone]=Yes,
[HomePhone#],""))

Can this be done OR is there a better way to do it that I'm missing?

I actually figured it out. Can Shrink on the fields...not the Detail
section.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top