Thanks Allan
As usual your advice is top notch. Keep up the good work
rgds
J
"Allen Browne" <AllenBrowne@SeeSig.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.stir.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]
