Typename? or other function?

  • Thread starter Kathy - Lovullo
  • Start date
K

Kathy - Lovullo

I am trying to create a field in a report header that will show one value if
a form a form was used to run the report and another to show if the form was
not used and is therefore not open.

I was originally trying to use the typename function but this doesn't seem
to be working.

Here is the Control Source of my report field:

=iif(typename([forms]![myForm])="Empty","Form is Open","Form is Closed")

Regardless of whether or not "myForm" is open, the report prints with "Form
is Open".

Is there another function to accomplish this? Or am I doing something
incorrectly?

Thanks in advance for any help!
 
Top