[AccessD] hide blank fields in Reports

Rocky and Don
Thank's a lot

/kostas

----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, March 23, 2007 1:12 AM
Subject: Re: [AccessD] hide blank fields in Reports


> Kostas:
>
> I have solved something like this problem before by making the height of 
> the
> text box zero that is bound to the field in question, and setting the 'Can
> Grow' property to true.  However, if you've got a label you've got to set
> it's height to zero, but then in the On Format event of the section it
> appears in, you have to set the height of the label depending on if there 
> is
> data in the bound text box.  Mostly my labels are in the heading section 
> so
> I don't have to mess with them.
>
> HTH
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas
> Konstantinidis
> Sent: Thursday, March 22, 2007 1:02 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] hide blank fields in Reports
>
> hi group,
> I want to hide the blank fields and the placeholders too in a report.
> e.g.
> Record 1
> Field A:
> Field B: result1
> Field C: result2
> Field D:
> Should look like this:
> Record 1
> Field B: result1
> Field C: result2
>
> trying the
> If Len(Nz(Me.Myfieldname)) > 0 Then
>   Me.mylabelname.Visible = True
> Else
>   Me.mylabelname.Visible = False
> End If
>
> it leaves the placeholder space of the hidden fields many thank's /kostas
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: 3/21/2007
> 7:52 AM
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>