PC Review


Reply
Thread Tools Rate Thread

Conditional format - Check for valid values

 
 
atledreier
Guest
Posts: n/a
 
      5th May 2010
I have a query that return values from a table. These fields should
all be filled with data, but some are not, and some are filled with
wrong data. I need to have my users validate the data in this form. I
am currently using conditional format and using yellow background to
make the NULL values stand out. I'd like to have the fields with non-
valid data have red text.

I'm not sure how to write the expression for that in the conditional
format setup.

Here's the query the form is based on. I need to mark the [tag]!
[function_code] control with red text when it has a value that does
not exist in the [WM_GOC_Conversion]![Function_Code] field

SELECT Tag.Tag, Tag.Description, Tag.Tag_cat, Tag.Function_code,
Tag_diverse.Disiplin, Tag.System, Tag_diverse.Comm_Pkg, Tag.Area,
[Tag_format_in/_br/_te].Fire_area, Tag.Loop,
WM_GOC_Conversion.Function_code
FROM ([Tag_format_in/_br/_te] INNER JOIN (WM_GOC_Conversion RIGHT JOIN
Tag ON WM_GOC_Conversion.Function_code = Tag.Function_code) ON
[Tag_format_in/_br/_te].Tag = Tag.Tag) INNER JOIN Tag_diverse ON
Tag.Tag = Tag_diverse.Tag
WHERE (((WM_GOC_Conversion.Function_code) Is Null) AND ((Tag.Flag) Is
Null)) OR (((Tag.Loop) Is Null) AND ((Tag.Flag) Is Null)) OR
(((Tag.Description) Is Null) AND ((Tag.Flag) Is Null)) OR
(((Tag.Tag_cat) Is Null) AND ((Tag.Flag) Is Null)) OR
(((Tag.Function_code) Is Null) AND ((Tag.Flag) Is Null)) OR
(((Tag_diverse.Disiplin) Is Null) AND ((Tag.Flag) Is Null)) OR
(((Tag.System) Is Null) AND ((Tag.Flag) Is Null)) OR
(((Tag_diverse.Comm_Pkg) Is Null) AND ((Tag.Flag) Is Null)) OR
(((Tag.Area) Is Null) AND ((Tag.Flag) Is Null)) OR ((([Tag_format_in/
_br/_te].Fire_area) Is Null) AND ((Tag.Flag) Is Null));
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check if string has valid DateTime format Magnus.Moraberg@gmail.com Microsoft C# .NET 1 1st Oct 2008 10:50 AM
Formula to check against a list of valid values Barb W Microsoft Excel Worksheet Functions 3 4th Mar 2008 06:51 PM
Retain Conditional Format When Condition Is No Longer Valid Rob Microsoft Excel Misc 6 20th Dec 2007 06:26 PM
Check if Conditional Format is True or False / Check cell Color =?Utf-8?B?S2V2aW4gTWNDYXJ0bmV5?= Microsoft Excel Worksheet Functions 5 29th Jun 2007 11:12 AM
How to check if a string is in a valid DateTime format? =?Utf-8?B?QW5kcmV3?= Microsoft Dot NET Framework Forms 3 13th Feb 2006 07:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:26 AM.