[AccessD] Conditional Formatting of Report Field-2 Based on ReportField-1

Brad

You can do a few things, but the simplest might be:

Leave the original (Field2) control with a transparent background and place
another control (Field2_Highlight) behind it ... Color the second control
and set the visible property based on the condition.

If Me.Field1 = "condition" Then
   Me.Field2_Highlight = " "
   Me.Field2_Highlight.Visible = True
Else
   Me.Field2_Highlight = ""
   Me.Field2_Highlight.Visible = False
End If

Regards,
Bob Gajewski
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, May 10, 2012 16:15 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Conditional Formatting of Report Field-2 Based on
ReportField-1

All,

I would like to highlight Field-2 (on a Report Detail line) when Field-1 (on
the same detail line) meets a certain condition.

This is an Access 2007 Report which is viewed in "Report" view by the users.
It is never printed.

Is this possible?

Thanks,
Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com