expression builder

[tonyl]

I'm trying to change a label caption in a report depending the value of a numeric field.
=IIf([55]=8,[Label176].[Caption]="Spring Term",[Label176].[Caption]="Summer Term")
[55] is the numeric field.
I get a type mismatch error. Any ideas?
Access 2010

[John_G]

Naming a field with only numeric digits is never a good idea - you never really know when it will confuse Access.

Where and how are you using that expression? The error might not be in the actual expression, but in how you are using it.

But try changing the name of [55] to F55 or similar to see if that works.

John

[tonyl]

thanks for advice re numeric fields, I will give it a try.
I'm using the expression in the report On Open and tried On Load.
Tony

[John_G]

I think your problem may be that you are putting your iif expression into the On Open property of your report. You can't do that - the setting can be only [Event Procedure], the name of a macro, or the name of a user-defined function, preceded by an = sign, e.g. =myfunction().

Which report event you put the code in will depend on where the label is used in the report, i.e. is it the same for the whole report, or does it change for each detail line?

I also have just noticed that you are not using the iif correctly. The iif function returns one of two values, depending on the condition - but it does not set the values within the parameter list as you have shown. Your code should look like this:

[Label176].[Caption] = IIf([55]=8,"Spring Term","Summer Term")

HTH

John