changing color of report field based on value

[Guest_imported]

I have MS Access 97 and I am trying to color in a field according to its value on a status report. For example if the value is green, I would like the field on the report to be green. Help says that there is an example in solutions.mdb, but I don't have that sample. It would be great if someone could post the code. Thanks!

 

[sko]

I'm not sure about Access 97 but in report design, select the control.

From the format menu, select conditional formatting. Fill in the condition 1 section.

 

[Garridon]

You can download the Solutions.mdb database from Microsoft's MSDN web site.

Otherwise, I'd say an If statement would be what you're looking for.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[AWithers]

This is some code I used bfore on the report detail_print event, hope you can follow the logic basically if the field datecompleted is not null then format the text black otherwise if it is null colour field 'comments' red


Hope this helps

Andy

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)


If Not Me.DateCompleted Then
'ensure black if completed
Comments.ForeColor = 0
Else

'colour text red

Comments.ForeColor = 255

End If

End Sub