IIF command for form?

  • Thread starter boomtap via AccessMonster.com
  • 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?
 
G

Graham R Seach

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
 
Top