IIF Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why is this function not listed in the Built-In Function list in Office 2003?
Or am I missing something?

Mary
 
sweeneysmsm said:
Why is this function not listed in the Built-In Function list in Office 2003?
Or am I missing something?
Click to expand...


What you're missing is the integrated Help in Access 97. It
can be difficult to find something when the help topics are
isolated to their specific library.

In the case of IIf, it is not a general office function.
Excel uses the IF function, while VBA has one IIf function
and Access's Expression Service used in queries (SQL) and
ControlSource (e.g. text box) expressions. The two
variations of IIf are very similar and for all practical
purposes can be used the same way.

The VBA IIf function Help topic can be found by using Help -
Index in the VB Editor window. Other keywords (including
some functions) are not found by the index search!? In
these cases, you can look in under the Contents tab - Visual
Basic Language - Functions.
 
I just looked and found it under Functions|Built-in Functions. I had <All>
selected in the middle box and scrolled through the alphabetical list in the
right hand box. It is listed as IIf (small F).
 
Back
Top