Adding a TON of text to a report

[RIck5150]

When I send a customer a work order, I want the final page to be a list of conditions of the current sale. In Word, it is nearly a full page of 7pt font with bold and italic. What is the best way to add this to the end of my report in Access?

 

[rzw0wr]

Memo field, set to can grow.
Set Text Format to Text Rich to get the Bold and Italics.

Dale

 

[RIck5150]

Sorry, so this should be added to the table and pulled into the form?

 

[rzw0wr]

If it is the same for all reports AND has Bold and Italics. I would look at putting in the code behind the report.
Format it just once and call it when you need it.

If you put it in the table with the other data you are storing lots of data you don't need to.

You can format it. put it in a table by it's self. You would have to then call it up with a Dlookup() function.
This may be the best way.

You can format the text in the table using Text Rich in the Text Format of the table then use HTML codes to bold and Italics.

Note: to start bold, <b>, to end bold /<b>
to start italic <i>, to end /<i>.
I think underline is <u>, /<u>

Dale

 

[RIck5150]

If it is the same for all reports AND has Bold and Italics. I would look at putting in the code behind the report.
Format it just once and call it when you need it.

Thank you for your help. This is exactly what I want to do. I do not understand how to put code behind the report though. I can write HTML so I am okay there...

 

[Mihail]

Hi !
May I ask a question, please ?

Dale:

If it is the same for all reports AND has Bold and Italics. I would look at putting in the code behind the report.

Why you not encouraged to put the text in an unbound text box, in the report footer ?
I haven't work with sophisticated reports. So I'm a newbie. So, please, explain your reasons. Thank you !

 

[nanscombe]

By writing it as a function, in a module, you could re-use it anywhere you wanted to by setting it as the Control Source of a Textbox.

If it were simply text in an unbound Textbox you would have to be sure to change it consistently everywhere it was used.

 

[Mihail]

Stupid brain. No mind about this .
Other reasons ?

 

[nanscombe]

If it were stored as text in a Memo field, contained in a table, someone could edit it without having to re-write the code behind your reports / database.

 

[rzw0wr]

Mihail, nanscombe please don't hijack this post. I find it very rude.
If you have a question use this post as a reference.

Thank you,
Dale

 

[rzw0wr]

rick,
After some thought, I would put your text in a table.
This table doesn't need to be related to the others.
When you want it in a report then use the following code.
DLookup("[MemoField]","Table")
If this is the only field/record in the table then no WHERE clause is needed.
This will also make troubleshooting easier.
If you need to change the wording of your text, it is in 1 place.

Dale

 

[nanscombe]

Mihail, nanscombe please don't hijack this post. I find it very rude.
If you have a question use this post as a reference.

Thank you,
Dale

Oi! In case you hadn't noticed, this is a PUBLIC forum so don't think you're going to get away with trying to pull that sort of nonsense.

if you have a problem with that, I suggest you take it up with the moderators.


RIck5150:
If the T&Cs are contained in a standard Word document, and you send out the work orders electronically, you could just attach it to an e-mail as a separate document with a line on the report saying see document such and such for full Terms and conditions and you wouldn't have to code anything at all.

 

[RIck5150]

Thanks Dale, I will give that a try. I have no experience with modules and they look complicated. Actually, it may be anyways, but I will give it a go. I appreciate it!

@nanscombe - I have the document as a PDF as well so it is more difficult to edit. By attaching it to a work order in a single PDF document, it would ensure they customer receives and opens it. I am concerned that the customer could say they received one document, but not the other. If I can attach it to each report and they approve the work order, I know they have received the document. Just trying to make it as foolproof as possible. The other option is to incorporate the the PDF each time using PDF ViewPlus or similar, but if I forget then shame on me.

 

[rzw0wr]

Rick, The dlookup() goes in an Unbound text box.

Dale

 

[nanscombe]

I've put together a demo of how data can be captured, and stored in Rich Text Format, into a memo field in a table (tblSnippets).

In the form frmSnippets you should be able to copy the entire contents of a PDF file and paste it into the Body field where it will automatically be converted, and stored, as Rich Text.

The demo is somewhat over-engineered but you should be able to pull it apart and study it to get some ideas for your own needs.

If nothing else, it should provide you with a way of converting your PDF document to Rich Text.

Manifest.Docx - Describes each of the files and Access database parts.

 

[Mihail]

Ok. Ok. I ask a question and I think that is "in thread". Thanks for info.
On the other hand, as far as I know, Access able the user to send automatic mails. And is not restricted to Access files. I don't use this facility, so I don't know enough to say "how to".
But, if Access can do that, why to not send an Access report and the .pdf file in a single message from within Access application ? This way, never forget to attach the .pdf file to the message.

 

[nanscombe]

If you take a look at the demo file that I've posted it can all be done from inside the report using a bit of Rich Text Formatted text, which has been stored previously, contained in a sub-report.

No need for a separate PDF file at all.

 

[RIck5150]

That is perfect! Thank you.


Is is possible to combine two DLookUp fields so I get the version number and the update date? I want the end result to look like this:


TCVer3.11a updated on June 29, 2013



I tried something like this, but it did not work.



=[DLookUp("TCVersion","TermsAndConditions","ID=1")] & " updated on " & =[DLookUp("TCVersionDate","TermsAndConditions","ID=1")]

 

[Mihail]

=[DLookUp("TCVersion","TermsAndConditions","ID=1")] & " updated on " & [DLookUp("TCVersionDate","TermsAndConditions","ID=1 ")]

 

[RIck5150]

That is what I tried first, but received a message stating Enter Parameter Value