IIF help

[StormcrowRahl]

I need help writing an IIF statement that will evaluate a calculated control(which calculates the sum of a column), to cause a page break when the sum is equal to 20.

 

[dhookom]

You can add a page break control in your report and then use code like:

If Me.txtCalcCtrl = 20 Then
    Me.pgbrkCtrl.Visible = True
  Else
    Me.pgbrkCtrl.Visible = False
End If

or

    Me.pgbrkCtrl.Visible = (Me.txtCalcCtrl = 20)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]