Filter (1 Viewer)

[Mark.Innes]

I have an expression on a report that works out a percentage between 2 fields. The expression is just on the report and not on a query so is it possible to filter out information based on this % expression?

 

[Rich]

You can hide fields based on a condition. Is that what you want to do?

 

[Mark.Innes]

Yes, that would certainly help

 

[Rich]

In the detail On_Format event
If Me.MyControl=Something Then
Me.SomeOtherControl.Visible=False
Else
Me.SomeOtherControl.Visible=True
End If

 

[Mark.Innes]

Thanks, that worked a treat