#Error on field

A

Andy G

I have this statement on a field in a report.

=IIf((IsNull([ALUMNI_Minor])),[ALUMNI_Major],[ALUMNI_Major] & "/" &
[ALUMNI_Minor])

If the person doesn't have a minor then just list the major, if they do have
a minor then insert a / inbetween the two. I get #Error. The name of the
filed that this expressision resides is "txtMajorMinor", I've also checked
and I do have ALUMNI_Major and ALUMNI_Minor in the query for the report.

Anyone...
Merci
 
K

Ken Snell [MVP]

In reports, if you want to use a field in an expression like this, you also
need to put a control (bound to the desired field) in the same section as
the control that is using this expression. To not have this other control be
visible, set its Visible property to No in design view.
 
Top