Control Source of a Text Box

A

Arlend Floyd

What is the proper syntax for Text box on a report for a If Statement. Here
is my sample:

If [TxtCkAmt] < 750 Then [TxtCkAmt] = 750

Else

[TxtBaseAmt] -[TxtCommAmt]

End If
 
R

Rick Brandt

Arlend said:
What is the proper syntax for Text box on a report for a If
Statement. Here is my sample:

If [TxtCkAmt] < 750 Then [TxtCkAmt] = 750

Else

[TxtBaseAmt] -[TxtCommAmt]

End If
Click to expand...

=IIf([TxtCkAmt] < 750, 750, [TxtBaseAmt] -[TxtCommAmt])

That's two "i"s as the function is named Immediate-If.
 
A

Arlend Floyd

Thanks Rick

Rick Brandt said:
Arlend said:
What is the proper syntax for Text box on a report for a If
Statement. Here is my sample:

If [TxtCkAmt] < 750 Then [TxtCkAmt] = 750

Else

[TxtBaseAmt] -[TxtCommAmt]

End If
Click to expand...

=IIf([TxtCkAmt] < 750, 750, [TxtBaseAmt] -[TxtCommAmt])

That's two "i"s as the function is named Immediate-If.
Click to expand...
 

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

Content Control Box Issue - Please Help! 0
Need help modifying code 0
Word OLE to check spelling in text box 1
Populate a table based on check box status 2
AppleScript - How do I select a text ? 1
MS Word normal.dot cannot be fixed 'text box' appears each time 4
VBA Export to PDF 0
Text field control source wont accept results of query 1

Top