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

Brad Marks BradM at blackforestltd.com
Thu May 10 21:52:49 CDT 2012


Doug and Bob,

Thanks for the advice/help, I appreciate it.

You folks are GREAT!

Brad 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Doug Steele
Sent: Thu 5/10/2012 4:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Conditional Formatting of Report Field-2 Based on Report Field-1
 
Hi Brad:

You can set up a Conditional Format rule for Field-2 with the highlighting
you want (bold, coloured text or background, whatever).  Then set the
condition to something like:

Expression is [Field-1]  > 2

If you're not familiar with conditional formatting, here is how to do it In
Access 2010 (I think it should be similar in 2007): in report design view,
select the Field-2 textbox; on the ribbon select 'Format' then 'Conditional
Formatting', then 'New Rule'.  Edit as required :)  The trick is to make
sure you put square brackets around any field name you use in the formula.

Doug



On Thu, May 10, 2012 at 1:14 PM, Brad Marks <BradM at blackforestltd.com>wrote:

> 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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





More information about the AccessD mailing list