RE: [MS_AccessPros] Re: "Do not Print" blank fields.

I generally change the label to a text box as set its control source to something like:
="Label Caption Value " + [Possibly Null Field Name]
Set the control width to only display the Label Caption Value. All the control to shrink but not grow.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: robinski@mymail.net.au
Date: Tue, 31 May 2011 09:42:14 +1000
Subject: Re: [MS_AccessPros] Re: "Do not Print" blank fields.

I have returned to this subject with a new report.

Is there any way to not show the label if a field is empty?

Many thanks,

Robin Chapple

At 27/07/2008 01:58 PM, you wrote:

>Set the Report's detail section's CAN SHRINK property to YES and then
>also the control's CAN SHRINK property to YES.
>
>Bob Larson
>Access MVP
>
>--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
><robinski@...> wrote:
> >
> > I have a report in which one field occupies one line and when it is
> > empty an ugly gap is left.
> >
> > How do I avoid the gap?
> >
> > Thanks,
> >
> > Robin Chapple
> >
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/