How can I highlight report fields?

[Leopardfist]

I use access 2003 Database with a switchboard front end. What I want to know if I can do is when I open a report, if it is possible to code in a way for the user to highlight a field or cell, and to choose to change the text to a different color.

Is this possible? Can anyone point me in the right direction to learn about this type of action?

 

[WayneRyan]

L,

If you know prior to opening the report, you can use Conditional Formatting to do this.

If you are doing it based on selecting a control on a form, then you're gonna have to
do something a little more complex, like stuffing a field name (or value) in an unbound
control on the form.

Then the report can use the OnFormat event (or maybe even Conditional Formatting) to do
what you want.

need more info,
Wayne

 

[mhartman]

http://forums.techguy.org/business-applications/577046-solved-ms-access-report-can.html

 

[mhartman]

http://support.microsoft.com/kb/304104/en-us