Eliminating labels 2when the field is blank

S

solriv

I would like to know how to set up Access so that when I make a report to
print a phone book that has labels like,
Home Phone
Work Phone
Fax
Mobile
and any of these fields are blank I would like to eliminate that label, and
move up a line to the next label the way outlook dos when you print a phone
book.
 
M

Maarkr

Private Sub Report_Page()
Me.Fax.Visible = True
If IsNull(Me.Fax) Then
Me.Fax.Visible = False
End If
End Sub

Be sure to set the fax field Can Shrink Property to Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top