Displaying fields in different colours

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

Guest

Hi,

I am a self-taught access user (didn't have a great teacher!!) and need a
little help.

I have a database that I use to track documents that require review. Within
it, I have a report that lists documents that have not been reviewed. What I
would like is for the persons name to be displayed in a red if they have not
reviewed the document and in green if they have. If they have reviewed the
document the date comments returned field is filled in but if they haven't it
is blank.

Do I set this up with the 'conditional formatting'? If so, what is the
expression I use?

Your help is much appreciated.

Thanks Nic
 
Hi,

I am a self-taught access user (didn't have a great teacher!!) and need a
little help.

I have a database that I use to track documents that require review. Within
it, I have a report that lists documents that have not been reviewed. What I
would like is for the persons name to be displayed in a red if they have not
reviewed the document and in green if they have. If they have reviewed the
document the date comments returned field is filled in but if they haven't it
is blank.

Do I set this up with the 'conditional formatting'? If so, what is the
expression I use?

Your help is much appreciated.

Thanks Nic
Click to expand...

First set the color of the Name control to Red.
Then, select the Name field.
Click on format + conditional formatting

Set the Condition1 Drop-down to:
Expression Is
Alongside, in the next box write:
Not IsNull([Comments])

Set the color to Green.
 
Fred,

That worked the treat!!!

Thanks heaps for your quick reply....much appreciated,
Nic

fredg said:
Hi,

I am a self-taught access user (didn't have a great teacher!!) and need a
little help.

I have a database that I use to track documents that require review. Within
it, I have a report that lists documents that have not been reviewed. What I
would like is for the persons name to be displayed in a red if they have not
reviewed the document and in green if they have. If they have reviewed the
document the date comments returned field is filled in but if they haven't it
is blank.

Do I set this up with the 'conditional formatting'? If so, what is the
expression I use?

Your help is much appreciated.

Thanks Nic
Click to expand...

First set the color of the Name control to Red.
Then, select the Name field.
Click on format + conditional formatting

Set the Condition1 Drop-down to:
Expression Is
Alongside, in the next box write:
Not IsNull([Comments])

Set the color to Green.
Click to expand...
 
Back
Top