UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Revising Report Control's Visible Property    
 
   
Retired
post May 18 2007, 12:04 PM
Post #1

UtterAccess Veteran
Posts: 386
From: Near Dallas, TX USA
Sorry, but I've read so many FAQ's and other postings my eyes are burning. But haven't found a fix that will probably end up being quite simple.

I would like to make the contents of a report control invisible dependent upon the contents of another control.
Away2TalkNo is a number control and Away2Spkr is a text control.

Here's the code I've used (under Detail_Format)
--------------------------------------------
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Away2TalkNo Is Null Then
Me.Away2Spkr.Visible = False
Else
Me.Away2Spkr.Visible = True
End If
End Sub
-------------------------------------------
Shouldn't this work?

Thanks, Jay Witt
Go to the top of the page
 
+
tunkefer
post May 18 2007, 12:06 PM
Post #2

UtterAccess Guru
Posts: 568
From: Cleveland, OH
Try this:
If IsNull(Me.Away2TalkNo) Then
Go to the top of the page
 
+
R. Hicks
post May 18 2007, 12:21 PM
Post #3

UA Forum Administrator
Posts: 38,131
From: Birmingham, Alabama USA
Try ...

CODE
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Away2Spkr.Visible = Not IsNull(Me.Away2TalkNo)
End Sub

RDH
Go to the top of the page
 
+
Retired
post May 18 2007, 12:57 PM
Post #4

UtterAccess Veteran
Posts: 386
From: Near Dallas, TX USA
Hello Tunkefer,

Yes, that did it! Thank you.

Lived near Cleveland in Lorain for over 30 years and 2 yrs in Garfield Heights. Miss the beautiful Ohio spring and fall weather . . . but not the wet cold winters!

Regards, Jay
Go to the top of the page
 
+
Retired
post May 18 2007, 01:04 PM
Post #5

UtterAccess Veteran
Posts: 386
From: Near Dallas, TX USA
Yes to you also!

Thanks, Jay Witt
Go to the top of the page
 
+
R. Hicks
post May 18 2007, 01:08 PM
Post #6

UA Forum Administrator
Posts: 38,131
From: Birmingham, Alabama USA
No problem .. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

RDH
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 06:34 AM