Control Source of a Text Box

  • Thread starter Thread starter Arlend Floyd
  • Start date Start date
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
 
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.
 
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...
 
Back
Top