second IF statement within the 1st

  • Thread starter Thread starter Squibbly
  • Start date Start date
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??
 
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.
 
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]
 
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...
 
Back
Top