Change Record colour if criteria not matched

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Conditional Formatting is your friend. While in form or report design,
go Format > Conditional Formatting.

HTH,
Nikos
 
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
 
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
 
Don't worry, it happens to everyone from time to time. Been there, and
I'm sure I'll be there again!
 
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.
 
Back
Top