Not sure if you ever received an answer to this but I just came across your question while trying to do exactly the same thing you are talking about. I was also looking for a way to set a variable and then use it in a rather long nested IIf statement.This seems to work:=IIf(Assign('$MyVariable','some value') <> 'BANANA', '', 0) +'Here is My Variable: ' + [$MyVariable]It fails to validate when I click the button but gives the desired result. I think you could put whatever you like in the IIf bit as long as it doesn’t match the thing you are assigning.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.