delete report fields if no data

[James]

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

[Allen Browne]

Re: delete report fields if no data

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.b.grant@stir .ac.uk> wrote in message
news:5uhjd3-j5s.ln1@nntp.st ir.ac.uk...[color=blue]
>
> 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[/color]

[James]

Re: delete report fields if no data

Thanks Allan

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

rgds
J

"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
news:44071b54$0 $21879$5a62ac22 @per-qv1-newsreader-01.iinet.net.au ...[color=blue]
> 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.b.grant@stir .ac.uk> wrote in message
> news:5uhjd3-j5s.ln1@nntp.st ir.ac.uk...[color=green]
>>
>> 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[/color]
>
>[/color]