hide row in a report based on value in a field

[tselie115]

i have a report with different fields, i need to hide the row where one of the fields, status is = to completed.
PS: i didnt remove it by query coz there are some fields from the same row still to be used for calculations.
thanks

 

[WayneRyan]

ts,

You can use conditional formatting. Select the field and go to

Format --> Conditional Formatting

Choose "Expression Is" and then enter:

[Status] = "Completed"

Set the color to the same color as your detail background and it's invisible,
but with a value, on the report.

Wayne

 

[RexesOperator]

ts,

You can use conditional formatting. Select the field and go to

Format --> Conditional Formatting

Choose "Expression Is" and then enter:

[Status] = "Completed"

Set the color to the same color as your detail background and it's invisible,
but with a value, on the report.

Wayne

I am trying to accomplish the same thing. How do I get the associated label to change?

 

[WayneRyan]

RO,

I don't think you can do that with Conditional Formatting. You'll probably
have to use the Detail Section's OnFormat event and put in VBA code to
do it.

Wayne

 

[RexesOperator]

That explains why it wouldn't work (something to add to the Access wish list).

I went with the KISS (Keep It Simple Stupid) principal and eliminated the label altogether:

="GST Exemption Number " & [GSTEXEMPTION]

I added enough spaces before the end quotes to make the [GSTEXEMPTION] field line up with the other controls.