[AccessD] hide blank fields in Reports

Kostas Konstantinidis kost36 at otenet.gr
Thu Mar 22 15:02:10 CDT 2007


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





More information about the AccessD mailing list