Inserting paragraph text into report problem

[hardrock]

Hi all, I need some help on a method to insert a paragraph of text into a report based on the country the report will go to. The paragraph(s) of text is basically some end user information and consists of 7 lines and 100 words. The wordings within the paragraph text are slightly modified for UK, Europe and US. The report already contains a text field called “country” that it gets from a query, so I guess this could be used to determine which paragraph gets inserted. What is the best solution to my problem? Thanks

 

[ted.martin]

If you create an unbound text box in the report and then depending on whether its in the Group Header, Group Footer or Details section, add the required text to the Declarations Format code.

e.g.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

myTxt = " this is the required text"

End Sub

For the various countries you need to select the appropriate text. This could be done in a variety of way e.g. Select Case or by using different text boxes making on the one you require visible etc.

 

[hardrock]

Hi ted, thanks for reply. The paragraph of text will hopefully be inserted into the detail section of the report. There will also be some additional data in the details section of my report from a query.

Also, when inserted text this way, is it possible to specify the text font and size? Thanks again.

 

[ted.martin]

Yes you can format the entire text box font and size by setting this in the normal way via the properties. However, if you want to partially format elements of the text, you will need to use a Rich Text Format text box. This is non-standard in Access and involves a 3rd party plug-in. Never used it myself but if this is what you really need, then try it. You will need to search for 'RTF text box'