[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