Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Mar 22 18:12:24 CDT 2007
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