IIF Functions (Access 97)

Topic

New Reply

Every where I look I

Reply | Quote

Replies

What context are you using this expression? In a query, on a form or in code?

Reply | Quote

This would be a Form or Code

Reply | Quote

Try this:
iif([txtHOLD]=TRUE,”Hold”,iif([txtRENT]=true,”Rent”,””))
The falsepart can be another if statement. The falsepart of your last if statement would contain the “”
Scott

Reply | Quote

If you’re doing this in Code, you should probably use a standard IF statement in the appropriate event (such as OnChange() or OnCurrent()):

If chkHold AND NOT chkRent Then
  txtResult  = "Item on HOLD"
Elseif NOT chkHold AND chkRent Then
  txtResult  = "Item on Rent"
Else
  txtResult  = ""
End If

Hope this helps

Reply | Quote

IIF statements are really designed for queries. The IF-End IF and SELECT CASE structures available in code are vastly preferable and much easier to disentangle than nested IIFs. Don’t be persuaded that it’s better to have everything on a single line. It buys you virtually nothing in modern programming languages and makes code much harder to maintain.

Reply | Quote