Forced page break(s) in Access 2007 report

[EdK]

Hi everyone

I am writing a book, using MS Access 2007 (seemed like a good idea at the time I started, and the report that creates the formatted book content works quite well).

The book content is "per paragraph" which gives me total flexibility to move content to whatever spot in the book I might wish, simply by changing the paragraph number (free field, not auto-number primary).


To save paper (or pages) in printing (or viewing) the book, I have the report printing off para by para (as many whole paras as will fit to a page). This is fine but I want each new chapter to start at a forced new page, for "presentation"/appearance sake.

The relevant fields for the purposes of this post are:

paranumber
paratext
chapternumber
forcepageifticked (a Yes/No box), which goes with each paragraph and which I thought might come in handy, I had in mind to link it to a page break control at the top of the "detail" part of the report in design view, and which would be "invisible" except if the report formatting process had got to the start of any chapter, and the Yes/no box was ticked. (I hope this makes sense?).

I have no experience with VBA at all, unfortunately, but could have a go at using any code that is suggested.

Is anyone able to help me with this, please?


EdK 1st October 2013

 

[spikepl]

seemed like a good idea at the time I started

... but you haven't changed your mind? Sure you can write a book using Access (as well as a typewriter or a pen), but all the normally useful features that you get in a tool dedicated to word processing like ... wait for it ... yes.. Word (!) are missing: Table of contentes, tale of figures, cross-references, references, index, footnotes, chapter-dependent page numbers, sections with separate numbering/formatting .., the list goes on and on...

 

[EdK]

Yep, I know, I know. But I like tinkering in/with Access. Word would be too easy .... And I can wait a lifetime pre-publishing. And if I pass on "unfulfilled" someone will discover it in a time capsule (hard drive) in a thousand years time and it will be a sensation. That's if there is still a human race by then .... Which is a moot point ....

So anyway, is there a clever access guru out there who can help with my question ?

EdK

 

[EdK]

Further to my previous post --

should the attached VBA code work to do what I want (as per my previous post)?

EdK