conditional line format in report

's Computer Specifications

I have a tabular report and I want to change the colour of certain line
in the report dependant on a conditional if statment, IF Then!

Cheers
Ne

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

's Computer Specifications

You can use code in the On Format event of the section that sets the
backcolor of the section.

--
Duane Hookom
MS Access MVP

"Nev" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> I have a tabular report and I want to change the colour of certain lines
> in the report dependant on a conditional if statment, IF Then!
>
> Cheers
> Nev
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I format line 1 in bold; when I unbold line 2, line 1 UNBOLDS	Jack	Microsoft Powerpoint	0	21st Sep 2009 05:17 PM
Conditional Format overwrighting previous conditional format	davethewelder	Microsoft Excel Programming	2	10th Apr 2008 04:01 PM
New Conditional Format Overriding Previous Conditional Format	Rene	Microsoft Excel Misc	3	27th Feb 2008 07:08 PM
Re: Multiple conditional on conditional format formula	Bob Phillips	Microsoft Excel Programming	0	27th Jul 2004 05:30 PM
format line missing when output report to Rich Text Format	=?Utf-8?B?WGF2aWVy?=	Microsoft Access Reports	2	13th Feb 2004 03:11 PM