Suppressing a blank field in a report

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

How do I suppress a blank field in a report so that it
doesn't take up a line?

In my report, I have the fields set-up like this:
Book Title Library Reimbursement Price
Library Notes (memo field)

I've set the "Book Title" and "Library Notes" field to
expanding and collapsing, but the "Library Notes" still
takes up a line even when empty. How do I "trim" the
field so that it doesn't even hold a place when there's
nothing there?

Thanks again, Jennifer
 
If the Library Notes text box has an attached label, the label will print,
and so the line won't collapse.

Replace the label with a text box that has these properties:
Control Source: =IIf([Library Notes] Is Null, Null, "Library Notes:")
Can Shrink Yes
Set the Height and Top exactly the same as the Library Notes text box, and
make sure they are not overlapping each other or anything else vertically on
the report.

Make sure the Can Shrink property of the Detail section is also set to Yes.
 
Hmmm, I had deleted the label, as all I need is the field
text (when present).

I have the shrink property of the detail section set to
Yes, but it still takes the space of a line when the
field is empty (again, there is no label)?

Thanks, Kay
-----Original Message-----
If the Library Notes text box has an attached label, the label will print,
and so the line won't collapse.

Replace the label with a text box that has these properties:
Control Source: =IIf([Library Notes] Is Null, Null, "Library Notes:")
Can Shrink Yes
Set the Height and Top exactly the same as the Library Notes text box, and
make sure they are not overlapping each other or anything else vertically on
the report.

Make sure the Can Shrink property of the Detail section is also set to Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

How do I suppress a blank field in a report so that it
doesn't take up a line?

In my report, I have the fields set-up like this:
Book Title Library Reimbursement Price
Library Notes (memo field)

I've set the "Book Title" and "Library Notes" field to
expanding and collapsing, but the "Library Notes" still
takes up a line even when empty. How do I "trim" the
field so that it doesn't even hold a place when there's
nothing there?

Thanks again, Jennifer
Click to expand...


.
Click to expand...
 
This worked for me! Thanks Allen!
-----Original Message-----
Hmmm, I had deleted the label, as all I need is the field
text (when present).

I have the shrink property of the detail section set to
Yes, but it still takes the space of a line when the
field is empty (again, there is no label)?

Thanks, Kay
-----Original Message-----
If the Library Notes text box has an attached label, the label will print,
and so the line won't collapse.

Replace the label with a text box that has these properties:
Control Source: =IIf([Library Notes] Is Null, Null, "Library Notes:")
Can Shrink Yes
Set the Height and Top exactly the same as the Library Notes text box, and
make sure they are not overlapping each other or anything else vertically on
the report.

Make sure the Can Shrink property of the Detail section is also set to Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

How do I suppress a blank field in a report so that it
doesn't take up a line?

In my report, I have the fields set-up like this:
Book Title Library Reimbursement Price
Library Notes (memo field)

I've set the "Book Title" and "Library Notes" field to
expanding and collapsing, but the "Library Notes" still
takes up a line even when empty. How do I "trim" the
field so that it doesn't even hold a place when there's
nothing there?

Thanks again, Jennifer
Click to expand...


.
Click to expand...
.
Click to expand...
 
Do you have the Can Shrink property of the text box also
set to Yes?
If you are using a form to input data, look at the
property sheet for the text box(?) for the Library Notes
field, and make sure there is nothing in Default Value.
Do the same for the field in the table.
If none of this helps, try deleting the text box and
replacing it with a new one. Sometimes they get confused
or stuck.
-----Original Message-----
Hmmm, I had deleted the label, as all I need is the field
text (when present).

I have the shrink property of the detail section set to
Yes, but it still takes the space of a line when the
field is empty (again, there is no label)?

Thanks, Kay
-----Original Message-----
If the Library Notes text box has an attached label, the label will print,
and so the line won't collapse.

Replace the label with a text box that has these properties:
Control Source: =IIf([Library Notes] Is Null, Null, "Library Notes:")
Can Shrink Yes
Set the Height and Top exactly the same as the Library Notes text box, and
make sure they are not overlapping each other or anything else vertically on
the report.

Make sure the Can Shrink property of the Detail section is also set to Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

How do I suppress a blank field in a report so that it
doesn't take up a line?

In my report, I have the fields set-up like this:
Book Title Library Reimbursement Price
Library Notes (memo field)

I've set the "Book Title" and "Library Notes" field to
expanding and collapsing, but the "Library Notes" still
takes up a line even when empty. How do I "trim" the
field so that it doesn't even hold a place when there's
nothing there?

Thanks again, Jennifer
Click to expand...


.
Click to expand...
.
Click to expand...
 
Back
Top