delete report fields if no data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James - 02 Mar 2006 16:09 GMT

Hi

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

Reply to this Message

Allen Browne - 02 Mar 2006 16:20 GMT

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.

Signature

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.

> I have a bibliographic report, author, title, abstract etc which always
> have data, and another field, ISBN, which can be blank.
[quoted text clipped - 5 lines]
> rgds and thanks
> J

Reply to this Message

James - 13 Mar 2006 10:33 GMT

Thanks Allan

As usual your advice is top notch. Keep up the good work

rgds
J

> Open the report in design view.
> Right-click the ISBN text box, and choose Properties.
[quoted text clipped - 24 lines]
>> rgds and thanks
>> J

Reply to this Message