second IF statement within the 1st

[Squibbly]

i have created an IF statement that when certain condition applies it will
make certain controls invisible, but not all conditions are being met, can i
put a second IF statement with the ELSE IF??

 

[Douglas J. Steele]

Can you give an example?

 

[Guest]

yes you can. i have done it many times. There is no real
limit to how many if statements you can nest inside other
if statements but if you have a lot, you might want to
consider select case instead.

 

[John Vinson]

yes you can. i have done it many times. There is no real
limit to how many if statements you can nest inside other
if statements but if you have a lot, you might want to
consider select case instead.

There is a limit (several hundred bytes, but not unlimited) on the
size of any query calculated field expression. If you have more than
two or three nested IIF's, you might want to use the Switch() function
instead. See the VBA online help for Switch.

John W. Vinson[MVP]

 

[Squibbly]

thank you and a happy new year

There is a limit (several hundred bytes, but not unlimited) on the
size of any query calculated field expression. If you have more than
two or three nested IIF's, you might want to use the Switch() function
instead. See the VBA online help for Switch.

John W. Vinson[MVP]