Eliminating blank lines

[Steve in S.F.]

I am creating a report that is a class roster listing information about the
parents of students in a school's classes.

The underlying table contains information about the students' parents. Each
student may have one or both parents and each parent may or may not have, for
example, a work phone, cell phone, or email address.

My problem is getting the report to list information only if it exists and
not leave a blank line when it doesn't. For example, if the father has a
work phone and the mother doesn't, the report should list the father's work
phone, but not leave a blank space for the mother's. Instead, the next line
should be filled with the next field's information.

I have a series of text boxes using the following formula (here's an example
for the work phone numbers):

TextBox: Text163 =IIf(Not IsNull([PHParent1WorkPhone]),"(" &
[PHParent1FirstName] & " - work) " & [PHParent1WorkPhone])
TextBox: Text164 =IIf(Not IsNull([PHParent2WorkPhone]),"(" &
[PHParent2FirstName] & " - work) " & [PHParent2WorkPhone])

I have set the "Can Shrink" property to "Yes" for both. Nonetheless, if
Parent1WorkPhone is blank in the table, I still get a blank space in the
report, followed by the Parent2WorkPhone.

What am I doing wrong here. Is there something wrong with the formula? Or
is there another method other than setting the the "Can Shrink" property. Or
some other solution?

Help!

Thanks,

Steve

 

[tina]

you said you set the CanShrink property of the control in the report. did
you also set the CanShrink property of the report *section* where the
control sits?

hth

 

[Steve in S.F.]

Yes -- doesn't seem to matter

you said you set the CanShrink property of the control in the report. did
you also set the CanShrink property of the report *section* where the
control sits?

hth

I am creating a report that is a class roster listing information about the
parents of students in a school's classes.

The underlying table contains information about the students' parents. Each
student may have one or both parents and each parent may or may not have, for
example, a work phone, cell phone, or email address.

My problem is getting the report to list information only if it exists and
not leave a blank line when it doesn't. For example, if the father has a
work phone and the mother doesn't, the report should list the father's work
phone, but not leave a blank space for the mother's. Instead, the next line
should be filled with the next field's information.

I have a series of text boxes using the following formula (here's an example
for the work phone numbers):

TextBox: Text163 =IIf(Not IsNull([PHParent1WorkPhone]),"(" &
[PHParent1FirstName] & " - work) " & [PHParent1WorkPhone])
TextBox: Text164 =IIf(Not IsNull([PHParent2WorkPhone]),"(" &
[PHParent2FirstName] & " - work) " & [PHParent2WorkPhone])

I have set the "Can Shrink" property to "Yes" for both. Nonetheless, if
Parent1WorkPhone is blank in the table, I still get a blank space in the
report, followed by the Parent2WorkPhone.

What am I doing wrong here. Is there something wrong with the formula? Or
is there another method other than setting the the "Can Shrink" property. Or
some other solution?

Help!

Thanks,

Steve

 

[Larry Linson]

Are there other Controls on the line with the Control you want to shrink?
Shrinking only works on whole lines... will not shrink just the Control, if
there's another unshrunken Control alongside it. That's the most common
cause of the effect you describe.

Also, the control should not be touching controls that are on preceding or
following lines... there should be a little space between them.

Larry

Yes -- doesn't seem to matter

you said you set the CanShrink property of the control in the report. did
you also set the CanShrink property of the report *section* where the
control sits?

hth

I am creating a report that is a class roster listing information about the
parents of students in a school's classes.

The underlying table contains information about the students' parents. Each
student may have one or both parents and each parent may or may not
have, for
example, a work phone, cell phone, or email address.

My problem is getting the report to list information only if it exists
and
not leave a blank line when it doesn't. For example, if the father has
a
work phone and the mother doesn't, the report should list the father's work
phone, but not leave a blank space for the mother's. Instead, the next line
should be filled with the next field's information.

I have a series of text boxes using the following formula (here's an example
for the work phone numbers):

TextBox: Text163 =IIf(Not IsNull([PHParent1WorkPhone]),"(" &
[PHParent1FirstName] & " - work) " & [PHParent1WorkPhone])
TextBox: Text164 =IIf(Not IsNull([PHParent2WorkPhone]),"(" &
[PHParent2FirstName] & " - work) " & [PHParent2WorkPhone])

I have set the "Can Shrink" property to "Yes" for both. Nonetheless,
if
Parent1WorkPhone is blank in the table, I still get a blank space in
the
report, followed by the Parent2WorkPhone.

What am I doing wrong here. Is there something wrong with the formula? Or
is there another method other than setting the the "Can Shrink"
property. Or
some other solution?

Help!

Thanks,

Steve

 

[Steve in S.F.]

Larry:

There are no controls on the same line, but they are "touching" contols
above and below (in order to try to create a block of text). I'll try
separating them a little as you suggest to see if that helps.

Thanks

Are there other Controls on the line with the Control you want to shrink?
Shrinking only works on whole lines... will not shrink just the Control, if
there's another unshrunken Control alongside it. That's the most common
cause of the effect you describe.

Also, the control should not be touching controls that are on preceding or
following lines... there should be a little space between them.

Larry

Yes -- doesn't seem to matter

you said you set the CanShrink property of the control in the report. did
you also set the CanShrink property of the report *section* where the
control sits?

hth


I am creating a report that is a class roster listing information about
the
parents of students in a school's classes.

The underlying table contains information about the students' parents.
Each
student may have one or both parents and each parent may or may not
have,
for
example, a work phone, cell phone, or email address.

My problem is getting the report to list information only if it exists
and
not leave a blank line when it doesn't. For example, if the father has
a
work phone and the mother doesn't, the report should list the father's
work
phone, but not leave a blank space for the mother's. Instead, the next
line
should be filled with the next field's information.

I have a series of text boxes using the following formula (here's an
example
for the work phone numbers):

TextBox: Text163 =IIf(Not IsNull([PHParent1WorkPhone]),"(" &
[PHParent1FirstName] & " - work) " & [PHParent1WorkPhone])
TextBox: Text164 =IIf(Not IsNull([PHParent2WorkPhone]),"(" &
[PHParent2FirstName] & " - work) " & [PHParent2WorkPhone])

I have set the "Can Shrink" property to "Yes" for both. Nonetheless,
if
Parent1WorkPhone is blank in the table, I still get a blank space in
the
report, followed by the Parent2WorkPhone.

What am I doing wrong here. Is there something wrong with the formula?
Or
is there another method other than setting the the "Can Shrink"
property.
Or
some other solution?

Help!

Thanks,

Steve