In my report, I want the value of the text field called "Client" to be overwritten with the word "Confidential" - if the Tick Box called "Client Confidential?" is ticked.

How do I do that ? In the report, or in the underlying query ? And how ?

NoVoice

In the textbox itself:

=IIf(ConfidentialCheckBox = True, "Confidential", "Client")

In the ControlSource property of the Client field I used the following.

=IIf([Client Name Confidential]=True,"Confidential",[Client])

It works OK in the True condition (ie the report said "Confidential"), but otherwise I got #Error. Is that because its a circular refererence ?

Before I put the IIf in there, the ControlSource said Client and it worked fine...

Eh ?

NoVoice

delete the original control and add the calculation you have to a new one

It worked ! Fantastico

NoVoice