Force page break

L

Les

On report's sorting/grouping properties, make an
expression like newbrk:mid(txtfld,1,2). You can create a
header/footer on this new field, and force page break.
-----Original Message-----
Hello,

I have to force a page break when the first 2 characters
Click to expand...
of a text field located in the description header
changes. Please help, this is the final step of this
report and I'm stumped!
 
J

John Spencer (MVP)

One of the properties in sorting and grouping is Group on. Set it to Prefix
Characters, Then set Group Interval to 2.

Now you are grouping on the first two characters of the field and can set Breaks
 

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 Breaks 4
Forcing Page Break 3
Unwanted page break 5
A Blank Page Follows the Report Header 2
print Report Footer on 2nd to last page and a chart on last page 1
Report/Subreport Problems with Sorting/Grouping, Access 2003 2
Force a page break in code 6
Intelligent page breaks so as to not separate header from data 1

Top