…= iif(ParcelIdentifier.IsVisible,[CropGroup],Null) produces an er

R

RaoultLeclerc

In my Access (2003) Database I have a report that includes the following
columns in a table:

ParcelIdentifier CropGroup Area ParcelNumber
Area1
A JPO 4,5 21/45
2,5
11
1,5

25/2 0,5

I want the report to hide selectively duplicate value in the table and to do
so; I used the formula as proposed by Allen Browne:

Control Source …… = iif(ParcelIdentifier.IsVisible,[CropGroup],Null)
The name of CropGroup is set as txtCropGroup
The hide duplicate property of all concerned variables is also set off

[ParcelIdentifier] ,[CropGroup] and [ParcelNumber] are defined as string
data type
Unfortunately the expression doesn’t work and I become prematurely an error:
Missing Operand

What am I doing wrong???

Thanks in advance for any help
 
Top