I saw a message from Microsoft recently that mentioned the standard IF ELSE END IF construction is much faster than IIF. I should qualify that this is in VB. Even though an IF ELSE has more commands to interpret (three versus, one) There is more overhead with IIF that if you are looking for speed fewer commands may not be better.


>Thanks, just wanted to find a faster way of setting values. I will be repeating these set of instructions about a 1000 times in loop.
>
>
>Nick