Highlight row in an Access Report

  • Thread starter Thread starter Donna Jo
  • Start date Start date
D

Donna Jo

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.
 
Are you talking about "Expression Is"? Can you tell me exactly how to write
it? Every time I try i get an error message.
 
Are you talking about "Expression Is"? Can you tell me exactly how to write
it? Every time I try i get an error message.
Click to expand...

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.
 
It worked!!! :-) Thank you.

Bill said:
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 said:
Are you talking about "Expression Is"? Can you tell me exactly how to
write
it? Every time I try i get an error message.
Click to expand...
Click to expand...
 
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
conditional formatting on one control? As it is right now only the on
control is highlighted.

Previous Posts In This Thread:

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

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

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

:

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 determin
if the color should change? For example, in the recor
source you might have a yes/no field named MyColorChg
even though not necess

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 th
information (i.e. the control name and criteria) needed to write th
expression,

Re: Highlight row in an Access Report
It worked!!! :-) Thank you

:

EggHeadCafe - Software Developer Portal of Choice
Professional ASP.NET Web Services [Wrox]
http://www.eggheadcafe.com/tutorial...2a0-dfe7948c05a1/professional-aspnet-web.aspx
 
Kara said:
What was the resolution to get the entire row highlighted instead of just the one field?
Click to expand...


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.
 
Back
Top