Create family directory with conditions

  • Thread starter Thread starter Angi
  • Start date Start date
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 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?
Click to expand...

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