Open the report in design view.
Right-click the ISBN text box, and choose Properties.
On the Format tab of the properties box, set Can Shrink to Yes.
Make sure the Can Shrink property of the (Detail?) section is also set to
Yes.
That allows the box to shrink, and the rest of the report will move up if
there is nothing else beside the text box. We still have to deal with the
label though.
Right-click the label, and choose Change To | Text box.
Set the Control Source of the text box to:
=IIf([ISBN] Is Null, Null, "ISBN:")
Set the Can Shrink property of this text box to Yes as well.
When the ISBN field is null, this one will be Null as well, and so it will
shrink. When ISBN is not null, this one will contain the text "ISBN:", which
looks just like the label.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"James" <j.*******@stir.ac.uk> wrote in message
news:5u************@nntp.stir.ac.uk...
I have a bibliographic report, author, title, abstract etc which always
have data, and another field, ISBN, which can be blank.
How can I format my report to delete the ISBN field and label, and move
the line up to a position underneath the new last field (given that the
ISBN field is deleted)
rgds and thanks
J
