if statements

J

JB

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
 
J

John Nurick

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.")
 

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

Page numbering with Merged Document and IF statements 1
Integrating information from Word to Excel (not mail merge) 1
XL solver question 0
Change Style to 'Keep with previous' instead of Keep with Next 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top