Change Record colour if criteria not matched

S

Songoku

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
 
N

Nikos Yannacopoulos

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

HTH,
Nikos
 
S

Songoku

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

Nikos Yannacopoulos

but what happens if it is in Access 97...........?
Click to expand...
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
 
R

RuralGuy

Nikos Yannacopoulos said:
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
Click to expand...

And then there is always Stephan Lebans:

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

HTH
 
R

RuralGuy

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

A2K or Higher Only!
Click to expand...

Oops...<shuffling feet and looking stupid>
 
N

Nikos Yannacopoulos

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

tamxwell

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.
 
Top