second IF statement within the 1st

S

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??
 
G

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.
 
J

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.
Click to expand...

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]
 
S

Squibbly

thank you and a happy new year

John Vinson said:
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]
Click to expand...
 
Top