anyway to automaticaly highlight records in a report if value is true?

[uapak90]

I am working on an employee training database and i was printing out reports on employees. One of hte fields indicate if their training is complete ont hat document or not. I was wondering, is there anwyay the incomplete records could stand out or liek whenever its incomplete, it highlights itslef or something..

 

[straybullet]

A number of ways to do this, two options:
You could set conditional formatting on the detail section which would change the backcolor if the Completed field is not filled or true/yes.
You could set the controls to conditionally be bold based on the same criteria.

Let them hate - so long as they fear... Lucius Accius

 

[Spenney]

Conditional Formatting (Format > Conditional Formatting...) may do what you require, though using VBA with 'OnFormat' event is more flexible if you get into more complicated condition criteria.

 

[uapak90]

thanks alot! thats exactly wat i was looking for.

 

[TheAceMan1]

. . . or in the [blue]On Format[/blue] event of the detail section:

[blue]   If Me!Textbox1 = "Completed" then
      Me!TextboxName.BackColor = 16777215 [green]'White Background[/green]
   Else
      Me!TextboxName.BackColor = 14277119 [green]'Light Red Background[/green]
   End If[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884: