Skipping Detail Lines

[sts125]

I have a report in Access 2007 that consist of a Report Header, Page Header, "Employee_ID" footer, Page Footer, and Report Footer.

I am basically printing a summary line for each employee ID with totals.

Currently I am not printing any detail lines, but would like to see if there is a way to conditionally print a detail line if a certain text field is not blank.

Is there a way to conditionally print a detail line, without affecting my summary totals? I don't want to print the detail line for blank values.

Thanks

 

[genomon]

Have a look in help at MoveLayout/NextRecord/PrintSection.


Sure, the early bird gets the worm, but the second mouse gets the cheese in the trap.

 

[dhookom]

I would add code to the On Format event of the Detail Section like:

Cancel = IsNull(Me.txtCheckMeForAValue)

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]