IIF command for form?

  • Thread starter Thread starter boomtap via AccessMonster.com
  • Start date Start date
B

boomtap via AccessMonster.com

I use the IIF command quite a bit in queries. Is there a simular command
(basically an IF / THEN statement) that can be used in a form?
 
If you're talking about using something in a ControlSource, RecordSource or
RowSource, then you can use IIF(), Choose(), or Switch(). If you're talking
about using it in VBA, you can use either IIF(), Choose(), Switch(), or the
If..End If construct, or the Select Case...End Select construct.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
 
Switch worked amazingly well. Thanks for the help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please Help! The Expression you entered is too complex 0
Choose append field based on criteria 4
IIF satement in a form 4
IIF function 9
Create Report Using Form Parameters 2
Specifying conditional Criteria in a Query or Report 6
EMail Command Button Problem 1
nested iif statements in a query 2

Back
Top