Baffling Problem

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
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?
 
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.
 
Back
Top