if statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been trying for who knows how long on how to put an if statement in an access form. Is there even a way to us an if statement? i need help, or at least an example of how set up and use the if statement. I have used the help in access and it doesn't seem to help any. if anybody has any suggestions please let me know
 
Hi JB,

It's not clear what you mean by "put an if statement on a form".

You can use the IIF() function in an expression in the ControlSource
property of a control such as a textbox. For instance, if there's a
field [Price] you could use something like this in a textbox:

IIF([Price]>=1000,"No way, Jose!","Oh well, if you really must.")
 
Back
Top