Baffling Problem

C

Chaplain Doug

Access 2002. I have a report whose detail section prints
the five fields of a table (query). When a text box
control is set to field [ReqLimit], the text box displays
(prints) with no problem. However, when I set the control
source of the text box to =iif([ReqType]="Check","Checked",
[ReqLimit]) the text box displays #ERR every time the iif
condition is false (i.e., every time it tries to display
[ReqLimit]). Again, if I just set the text box source to
[ReqLimit] it displays without error. I have already
tried using str([ReqLimit]) and I still get an error.
Also, when I try to reference the [ReqLimit] field in the
report code it cannot be found. Any clues as to what is
happening here?
 
A

Allen Browne

Try changing the Name property of the control.

Access gets confused if the control has the same name as a field (e.g. it's
called "ReqType") but is bound to an expression.
 
Top