Highlighting in Report

[Guest]

My underlying query for the report asks the user to enter the Grid ID. In
the table, the Grid ID consists of numbers like A25, B5, B6, E35. In the
report, I want the information for B5 to pop up. When I enter in B5 the
report shows up but in the Grid ID box A25, B5, B6, and E35 all show up. Is
there a way to highlight B5 in the report. So, I want the report to pop up
and whatever Grid ID was entered, I want to be highlighted or in a different
color text. Is this possible?

 

[Rick B]

Please do not post duplicate questions in separate newsgroups. If you get
an answer in one group, someone else may waste time giving you a second
answer and not be aware that you already have a response.

 

[Duane Hookom]

Have you looked at Conditional Formatting?

 

[Guest]

I have looked at conditional formatting. I said equal to Grid ID but then it
highlights everything instead of the specific grid I enter.

 

[Duane Hookom]

You have to use the "asks the user to enter" so the Grid ID is compared to
some unique value.

 

[Guest]

Where is the "asks the user to enter"?

You have to use the "asks the user to enter" so the Grid ID is compared to
some unique value.

 

[Duane Hookom]

Those are your words. You need to tell us what you mean by "query for the
report asks the user to enter the Grid ID".

The SQL view of your query might help.

 

[Guest]

The report has a paramater set that says Enter Grid ID. If I enter B5, the
report shows the information for B5. The information for B5 may be the same
for B6, and C5, and D8. So, in the report I want the B5 to be highlighted in
the string of text that contains all the Grid IDs. I tried the conditional
formatting and said equal to the Grid ID but when I run the report everything
turns a different color, not just B5. I'm unsure about how to write an
expression that will have just the Grid I want (grid entered) be a different
color

 

[Duane Hookom]

You must compare the grid id field/text box to the expression [Enter Grid
ID].