• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

How can I force a new page within a RTF Text Box in Access

Hello Experts,

In an Access application, I try to force a page break within a Rich Text Text Box.
In VisualBasic, when I fill a memo field with <div>Text</div>, I can control the line return. Is there an equivalent for page break ?
I know how to force a page break between two field in an Access Report but I really need to force a page break in the middle of a large memo field.

Thank you for your answers.
0
Galadorn
Asked:
Galadorn
  • 4
  • 4
1 Solution
 
peter57rCommented:
I doubt whether you can do this at all, but can you just explain how you would work out where the page break was to fall, if it were possible.
0
 
Jeffrey CoachmanMIS LiasonCommented:
A Textbox is just that, a "Text"Box, it is not a "Document"Box..

Even if you used an OLE field, the document gets opened in the native application.
So the Page break would still be displayed there.
Perhaps this would be a better option for you...

Besides, even if this were possible in a Textbox, I have no knowledge of any interface tool that could "navigate" through the "Pages" of a document in this textbox.

So perhaps you could *first* explain your ultimate goal here....


JeffCoachman
0
 
GaladornAuthor Commented:
It's an application for a very demanding customer.
A big database of options is used to create a contract for building or modifying a house.
The secretary choose/pick the different options in the DB thru a form according to the need/demand of the client. And a PDF is then generated thru a report.
Each options are made of an ID, a price and a long description made of bold and underline text, paragraph etc.. And each option is editable by the user. So I choose memo type field for the description of the options. Everything works well except that, depending on the length (number of lines) of one option, page break creates white spaces at the bottom of the page.
So now, my customer ask me to be able to page break one option at the line he chooses to achieve a better presentation and avoid too wide blank at the bottom of pages.

Another solution would be to split the memo field in two in VB, depending on where the secretary has placed a special tag in the memo field but I just wanted to ask you for a quicker/simpler/better solution.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jeffrey CoachmanMIS LiasonCommented:
...But again, as I stated, ...a textbox/rich textbox cannot really display "Page breaks".
So can you state what your reference for this functionality is?

AFAIK, a textbox/richtextbox has no way of dealing with a "Page break".
In other words, what are you expecting to see as a "Page Break"
(why not just use a line break or CRLF, ...etc, ... or even <Div>?)

Finally, lets be clear on the terminology.
RTF stands for "Rich Text Format"
This is similar to, ...but not the same as HTML.
In Access 2003 and older, this was true RTF.
In Access 2007 and newer format databases "Rich Text" is really HTML


So we need to also clarify:
What *version* of Access you are using
What Access "Format" the DB is in (This is not the same as the "Version")
If you are generating HTML or true Rich Text

0
 
GaladornAuthor Commented:
This is full Access 2007 and I simply use built in memo type field.
By the way, I'm confused with what it uses : HTML or RTF ? It seems to be more HTML than RTF even if it names it RTF.
I already use <div></div>, <em><strong>... And when you edit a memo text box and you press CTRL-ENTER, it generates <div></div> automaticaly. Same thing with bold (gives <strong>) ...
Not sure how to answer to your "Format" question, sorry. I edit memo field thru a form and when I browse it thru table view, I see tags like <div>, <em>, <strong>...
But if it is HTML, I should be able to force new page with a single tag, am I right ?
0
 
Jeffrey CoachmanMIS LiasonCommented:
<I'm confused with what it uses : HTML or RTF ?>
An Access 2007 "Format" database (.accdb) really uses HTML.
(Access 2003 format databases (.mdb) use true Rich Text
I think MS left the name "Rich Text" so as not to "Shock" previous users into thinking that they now had to learn HTML.  
Basically the coded text was always transparent to the user.
All Rich text (and now HTML) formatting allows you to do is format the text easily.


<But if it is HTML, I should be able to force new page with a single tag, am I right ?>
One more time...
A textbox/richtextbox, (or whatever) has no concept of a "Page break".
Line break, ...yes
CR/LF, ...yes
...but not really a "Page break"
I am still unclear of what you are expecting to see with this page break... or what you are trying to accomplish...

Remember that this HTML provides "Basic formatting" only (no css, no xml, ...etc)
Also not that in basic html there is no distinct "Page Break" tag, so again, I am confused as to what you are expecting to see with this "Page Break"

Perhaps I am misunderstanding something, can you post a graphical example of *exactly* what you are expecting to see in your control with text before and after this "page break"...?

(You can see here if you are interested in doing this manually, but this is another topic entirely...)

If you are looking for a direct answer here, ...that answer would seem to be:
    No, this is not possible with Access 2007 (accdb) Rich text/html/memo fields.  

JeffCoachman
0
 
GaladornAuthor Commented:
I'm not surprised by your answer, I was beginning to think the same way.
In fact, the user want that page breaks occurs exactly where he wants according to the meaning of the text. Which is programmatically impossible. I'm almost sure that I won't be able to find rules for this kind of problem because each case will be particuliar.

And if the user can't insert a tag within the memo field that force a page break neither, I think I have no other choice to output the report in a Word document (have seen that before in Access). From Word, the user can do everything to arrange the page and dynamically (now he has to go in the form and generate a pdf to see the result of his changes).
I don't know if there's PDF modifiers that can insert page break or add lines and not costing 500$, I'm not very familiar with this kind of programs.
Because converting my reports to Word documents is not my favorite solution neither because it will cost lot of times. It's a complex report and using the automatic export process to Word gives awful results.
0
 
GaladornAuthor Commented:
Thanks for your explanations.
0
 
Jeffrey CoachmanMIS LiasonCommented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now