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

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Conditional format null fields    
 
   
bscott
post Oct 3 2007, 12:47 PM
Post #1

UtterAccess Member
Posts: 33
From: Washington



Can I set up conditional formatting to highlight fields that cantain Null values? All attempts have not worked.

Thank you,

BScott
Go to the top of the page
 
+
theDBguy
post Oct 3 2007, 01:08 PM
Post #2

Access Wiki and Forums Moderator
Posts: 47,919
From: SoCal, USA



Have you tried:

Expression is: [field] Is Null

HTH
Go to the top of the page
 
+
bscott
post Oct 3 2007, 03:10 PM
Post #3

UtterAccess Member
Posts: 33
From: Washington



Thank you, thought I tried that earlier, think I typed the control source wrong. Works great.
Go to the top of the page
 
+
theDBguy
post Oct 3 2007, 04:24 PM
Post #4

Access Wiki and Forums Moderator
Posts: 47,919
From: SoCal, USA



You're welcome. Glad it worked. Good luck with your project.
Go to the top of the page
 
+

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

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 07:56 AM