If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Eliminating blank lines
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 |
#2
|
|||
|
|||
Eliminating blank lines
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." wrote in message ... 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 |
#3
|
|||
|
|||
Eliminating blank lines
Yes -- doesn't seem to matter
"tina" wrote: 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." wrote in message ... 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 |
#4
|
|||
|
|||
Eliminating blank lines
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 "Steve in S.F." wrote in message ... Yes -- doesn't seem to matter "tina" wrote: 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." wrote in message ... 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 |
#5
|
|||
|
|||
Eliminating blank lines
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 "Larry Linson" wrote: 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 "Steve in S.F." wrote in message ... Yes -- doesn't seem to matter "tina" wrote: 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." wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|