WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Eliminating labels 2when the field is blank

 
   Home -> Office other -> Getting Started RSS
Next:  Data entry in Access  
Author Message
solriv

External


Since: Aug 28, 2008
Posts: 1



(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.
Back to top
Login to vote
Maarkr

External


Since: Jul 27, 2007
Posts: 63



(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.
>
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> Getting Started 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET