highlight a record

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

ok i have a report and my boss wants to see all the
records on this report but he would like to be able to
like highlight the report to show the ones he already
reviewed is there some way to highlight these like in
yellow or something to make them stand out from the rest
 
Hightlisght what? How does Access know which ones "he has reviewed"? Is
there a flag for this in the database somewhere?

Rick B
 
i have a date field with a date in it if no date then he
hasnt reviewed it im using if logic but it doesnt seem to
be working
 
Sounds like you would use conditional formatting to tell it that if the date
field is blank, then print the line in bold, or in another color, etc.

I'd use conditional formatting if it were me.

Rick B
 
i believe your talking if logic in the report?
something like =IIf([DonReview] Is Not Null,"*",Null)
how would i tell it to bold or change color of line?
 
Use CONDITIONAL FORMATTING (it is explained well in Access help).

Highlight each field in your detail section (one at a time) and then clieck
the Format Menu, then click Conditional Formatting.

In the dialog box that appears, select "Expression Is" in the first
drop-down box. In the next field, put something like....

Isnull([DateReviewed])

Then click the Bold symbol, Italics, change the color, or whatever you
decide to do.

Repeat this for each field in your detail section.

Use the built-in Access Help feature if you need more details on how to use
conditional formatting.

Rick B

Dan said:
i believe your talking if logic in the report?
something like =IIf([DonReview] Is Not Null,"*",Null)
how would i tell it to bold or change color of line?
-----Original Message-----
Sounds like you would use conditional formatting to tell it that if the date
field is blank, then print the line in bold, or in another color, etc.

I'd use conditional formatting if it were me.

Rick B




.
Click to expand...
Click to expand...
 
Back
Top