(Msg. 1) Posted: Thu Aug 28, 2008 2:27 pm
Post subject: Eliminating labels 2when the field is blank Archived from groups: microsoft>public>access>gettingstarted (more info?)
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.
(Msg. 2) Posted: Fri Aug 29, 2008 5:40 am
Post subject: RE: Eliminating labels 2when the field is blank [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
"solriv" wrote:
> 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.
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum