Change Record colour if criteria not matched

[Guest]

Hi,

is there a way to have a record change color if certain criteria is not
matched?

for example my database has records based on date issued and date recieved,
so if the date recieved is null or date issued+7 days < current system date
that record should change to red

any help mucho appreciated!!

Cheers

 

[Nikos Yannacopoulos]

Conditional Formatting is your friend. While in form or report design,
go Format > Conditional Formatting.

HTH,
Nikos

 

[Guest]

Appreciate that Nikos...........
but what happens if it is in Access 97...........?

 

[Nikos Yannacopoulos]

but what happens if it is in Access 97...........?

So, conditional formatting as not available in A97? Sorry, I haven't
used A97 for years, I didn't know. You could use some simple code to do
it, the catch is it will only work in single form view; in continuous
forms view you cannot change the format settings for a single record,
whatever change is applied to all records at once.

Nikos

 

[RuralGuy]

So, conditional formatting as not available in A97? Sorry, I haven't
used A97 for years, I didn't know. You could use some simple code to
do it, the catch is it will only work in single form view; in
continuous forms view you cannot change the format settings for a
single record, whatever change is applied to all records at once.

Nikos

And then there is always Stephan Lebans:

http://www.lebans.com/conditionalformatting.htm

HTH

 

[Nikos Yannacopoulos]

And then there is always Stephan Lebans:

http://www.lebans.com/conditionalformatting.htm

Of course... the only problem is, the first line on the page reads:


A2K or Higher Only!

 

[RuralGuy]

Of course... the only problem is, the first line on the page reads:

A2K or Higher Only!

Oops...<shuffling feet and looking stupid>

 

[Nikos Yannacopoulos]

Don't worry, it happens to everyone from time to time. Been there, and
I'm sure I'll be there again!

 

[Guest]

now where were we.....ah yes any recommendations as to how to achieve this?

 

[Guest]

Did you ever get an answer as to wheather or not ths can be done. If I
understand you correctly, you want the change to take place when the query is
ran? I have a field that is for disputed items, when the Cm's run thier
daily queries if an item has been marked "Disputed" I need the record to
change to red. I don't use reports just queries, and I have a main form where
the queries are listed.