Change the control Source in a textbox in a Report. (1 Viewer)

AccOUCH

Registered User.
Local time
Today, 14:20
Joined
Sep 27, 2018
Messages
25
Change the Control Source of a TextBox in a report. Like the one shown in this image:


Screen capture

My aim is to exclude from this control results that are compabtile with the string above depicted so I've written:

Code:
=[FormaPago] <> "Transferencias SVS-Mutuas"

But it does not work. So my question to all the community is clear: How to prevent some strings that show the kind of FormaPago (there are several) to be printed in the report.

Why the way I've used is not correct? How to solve this?
 

June7

AWF VIP
Local time
Today, 13:20
Joined
Mar 9, 2014
Messages
5,466
=IIf([FormaPago] = "Transferencias SVS-Mutuas", Null, [FormaPago])

Or apply filter criteria to report so those records are not retrieved.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 05:20
Joined
May 7, 2009
Messages
19,229
use Conditional Formatting.
 

June7

AWF VIP
Local time
Today, 13:20
Joined
Mar 9, 2014
Messages
5,466
@arnelgp, could you clarify how CF applies?
 

Users who are viewing this thread

Top Bottom