Highlight row in an Access Report

Donna Jo · External Since: Mar 17, 2009 Posts: 3

How do I get and entire row to highlight based on the results of a
conditional formatting on one control? As it is right now only the one
control is highlighted.

Bill · External Since: Jan 10, 2009 Posts: 12

Donna Jo,
Conditional formatting works perfectly for something like
you describe. E.g., if MyTriggerField = True, then set
color to whatever you want.
Bill

"Donna Jo" <DonnaJo RemoveThis @discussions.microsoft.com> wrote in message
news:2195D5BE-076D-45C2-86E5-D80045CF27E3@microsoft.com...
> How do I get and entire row to highlight based on the results of a
> conditional formatting on one control? As it is right now only the one
> control is highlighted.

Donna Jo · External Since: Mar 17, 2009 Posts: 3

Are you talking about "Expression Is"? Can you tell me exactly how to write
it? Every time I try i get an error message.

"Bill" wrote:

> Donna Jo,
> Conditional formatting works perfectly for something like
> you describe. E.g., if MyTriggerField = True, then set
> color to whatever you want.
> Bill
>
> "Donna Jo" <DonnaJo DeleteThis @discussions.microsoft.com> wrote in message
> news:2195D5BE-076D-45C2-86E5-D80045CF27E3@microsoft.com...
> > How do I get and entire row to highlight based on the results of a
> > conditional formatting on one control? As it is right now only the one
> > control is highlighted.
>
>
>

Bill · External Since: Jan 10, 2009 Posts: 12

Donna Jo,

What's the name of the field you would test to determine
if the color should change? For example, in the record
source you might have a yes/no field named MyColorChg,
even though not necessarily visible, would determine what
color you want to print the current record. Using the
"Expression Is" option you would code the expression as:
[MyColorChg]=True in the adjacent pane and set the color
you desire.

Bill

"Donna Jo" <DonnaJo RemoveThis @discussions.microsoft.com> wrote in message
news:3B8738FF-F1F8-4F40-89B2-1C7375472A21@microsoft.com...
> Are you talking about "Expression Is"? Can you tell me exactly how to
> write
> it? Every time I try i get an error message.
>
> "Bill" wrote:
>
>> Donna Jo,
>> Conditional formatting works perfectly for something like
>> you describe. E.g., if MyTriggerField = True, then set
>> color to whatever you want.
>> Bill
>>
>> "Donna Jo" <DonnaJo RemoveThis @discussions.microsoft.com> wrote in message
>> news:2195D5BE-076D-45C2-86E5-D80045CF27E3@microsoft.com...
>> > How do I get and entire row to highlight based on the results of a
>> > conditional formatting on one control? As it is right now only the one
>> > control is highlighted.
>>
>>
>>

fredg · External Since: Jan 30, 2004 Posts: 3580

On Tue, 17 Mar 2009 12:27:02 -0700, Donna Jo wrote:

> Are you talking about "Expression Is"? Can you tell me exactly how to write
> it? Every time I try i get an error message.
>
> "Bill" wrote:
>
>> Donna Jo,
>> Conditional formatting works perfectly for something like
>> you describe. E.g., if MyTriggerField = True, then set
>> color to whatever you want.
>> Bill
>>
>> "Donna Jo" <DonnaJo.RemoveThis@discussions.microsoft.com> wrote in message
>> news:2195D5BE-076D-45C2-86E5-D80045CF27E3@microsoft.com...
>>> How do I get and entire row to highlight based on the results of a
>>> conditional formatting on one control? As it is right now only the one
>>> control is highlighted.
>>
>>

And you wrote what? And the Error Message was what?

Wouldn't it have been more efficient for YOU to have given us the
information (i.e. the control name and criteria) needed to write the
expression, rather then us guessing as to what it is you are
specifically trying to do?

The answer depends upon what you mean by entire row (each control in
the row.. or just the background of the row).
Perhaps placing code in the Report's Detail Format event is all you
need do.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Donna Jo · External Since: Mar 17, 2009 Posts: 3

It worked!!! Smile

Thank you.

"Bill" wrote:

> Donna Jo,
>
> What's the name of the field you would test to determine
> if the color should change? For example, in the record
> source you might have a yes/no field named MyColorChg,
> even though not necessarily visible, would determine what
> color you want to print the current record. Using the
> "Expression Is" option you would code the expression as:
> [MyColorChg]=True in the adjacent pane and set the color
> you desire.
>
> Bill
>
>
>
> "Donna Jo" <DonnaJo RemoveThis @discussions.microsoft.com> wrote in message
> news:3B8738FF-F1F8-4F40-89B2-1C7375472A21@microsoft.com...
> > Are you talking about "Expression Is"? Can you tell me exactly how to
> > write
> > it? Every time I try i get an error message.
> >
> > "Bill" wrote:
> >
> >> Donna Jo,
> >> Conditional formatting works perfectly for something like
> >> you describe. E.g., if MyTriggerField = True, then set
> >> color to whatever you want.
> >> Bill
> >>
> >> "Donna Jo" <DonnaJo RemoveThis @discussions.microsoft.com> wrote in message
> >> news:2195D5BE-076D-45C2-86E5-D80045CF27E3@microsoft.com...
> >> > How do I get and entire row to highlight based on the results of a
> >> > conditional formatting on one control? As it is right now only the one
> >> > control is highlighted.
> >>
> >>
> >>
>
>
>

Kara White · External Since: Oct 20, 2009 Posts: 1

Hi,
What was the resolution to get the entire row highlighted instead of just the one field?
Thanks.

DonnaJ wrote:

Highlight row in an Access Report
17-Mar-09

How do I get and entire row to highlight based on the results of a
conditional formatting on one control? As it is right now only the one
control is highlighted.

Previous Posts In This Thread:

On Tuesday, March 17, 2009 1:33 PM
DonnaJ wrote:

Highlight row in an Access Report
How do I get and entire row to highlight based on the results of a
conditional formatting on one control? As it is right now only the one
control is highlighted.

On Tuesday, March 17, 2009 2:04 PM
Bill wrote:

Donna Jo,Conditional formatting works perfectly for something likeyou describe.
Donna Jo,
Conditional formatting works perfectly for something like
you describe. E.g., if MyTriggerField = True, then set
color to whatever you want.
Bill

On Tuesday, March 17, 2009 3:27 PM
DonnaJ wrote:

Are you talking about "Expression Is"?
Are you talking about "Expression Is"? Can you tell me exactly how to write
it? Every time I try i get an error message.

"Bill" wrote:

On Tuesday, March 17, 2009 4:03 PM
Bill wrote:

Donna Jo,What's the name of the field you would test to determineif the color
Donna Jo,

What's the name of the field you would test to determine
if the color should change? For example, in the record
source you might have a yes/no field named MyColorChg,
even though not necess

On Tuesday, March 17, 2009 4:24 PM
fredg wrote:

Re: Highlight row in an Access Report
And you wrote what? And the Error Message was what?

Wouldn't it have been more efficient for YOU to have given us the
information (i.e. the control name and criteria) needed to write the
expression,

On Tuesday, March 17, 2009 4:48 PM
DonnaJ wrote:

Re: Highlight row in an Access Report
It worked!!! Smile

Thank you.

"Bill" wrote:

EggHeadCafe - Software Developer Portal of Choice
Professional ASP.NET Web Services [Wrox]
http://www.eggheadcafe.com/tutorials/aspnet/3ef0c5cd-a221-4376-a2a0-df...48c05a1

Marshall Barton · External Since: Dec 07, 2003 Posts: 5120

Kara White wrote:
>What was the resolution to get the entire row highlighted instead of just the one field?

I have no idea what that thread lead to. You must be using
some strange web site to get to these forums and it makes a
hash of the thread, IMO, it's better to use an email
program (Outlook Express, Agent, etc) instead of a browser
web site.

To answer your specific question, Add a text box to the
report's detail section and size it to fill the entire
detail section. Use conditional formatting on this new text
box to get the color you want. Then use the Format - Send
To Back menu item to put the text box behind all the other
controls and Set all the other control's BackStyle property
to Transparent.

--
Marsh
MVP [MS Access]