IF statements in text boxes on Forms

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Please can anyone let me know whether it is possible to
use things like IF statements in formulae entered into
text boxes on Accesss Forms? If so, should the format of
the statement be similar to that used in an IF statement
in an Excel cell?

I'm trying to do this (using values from other text boxes
and forms in the formula too) but am having problems
getting it to work, and one of the problems seems to be
with its recognition of the IF statement.

Many thanks.
 
YES!

If you create a text box and enter an iff statement similar to the
following, you should get what you are looking for:

=IIf([SomeFieldName],"The field is true.","The field is false.")

Rick
 
Back
Top