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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Text box behavior on a subreport    
 
   
NineIron
post May 16 2005, 01:30 PM
Post #1

UtterAccess Ruler
Posts: 1,895
From: Massachusetts
I am using the following code to change the backcolor of a textbox:

CODE
If IsNull(strEye) = True Then
        Reports![AdultChecklist_Individual]![sr_Diabetes].Report![r_HedisEyeExam].Report![MaxOfresult_dt].BackColor = 12632256
    End If


Trouble is...it doesn't work. strEye is the value of the textbox. If it is NULL, I want the textbox to show up gray. This will alert the user to fill in the value. If Not IsNull is TRUE, I can get the text box to change colors. This is driving me nuts!!!!!!!
Any thoughts?
Go to the top of the page
 
+
freakazeud
post May 16 2005, 01:36 PM
Post #2

UtterAccess VIP
Posts: 31,413
From: NC, USA
Hi,
You don't need to check if it is true or not. Either it is null or not.
So just do:
If IsNull(Me.strEye) Then...

On the other hand you can just use conditional formatting.
ACC2000 and higher has a feature called conditional formatting. No need for VBA.
Check this out:

conditional format reports

HTH
Good luck
Go to the top of the page
 
+
NineIron
post May 17 2005, 06:41 AM
Post #3

UtterAccess Ruler
Posts: 1,895
From: Massachusetts
This is perfect. Thanx.
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: 20th May 2013 - 06:54 AM