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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Include an IF statement in Concatenated Text 10
If Then Statements 2
expression in form 4
wildcards in an If statement 6
Can't Format Text Box 2
Excel Excel IF statement with 3 outcomes 1
Conditional statement in a text box? 2
using OR in form text boxes 3

Back
Top