How to Hardcode 7,000 Bytes of Text on a Report

[Guest]

Hi,
I'm using Access 2003 and I need to hardcode "conditions of sale" text into
the report footer of an Access report; the text is about 7,000 characters and
that seems to be too much text for a textbox or a label to hold. What's the
best way to hard code a lot of text onto a report?
Also, the conditions are broken up into about 10 sections each beginning
with a short description of a couple of words which need to be bolded and
underlined. And each section needs to be numbered. An example is shown
below; I placed the text which needs to be bolded and underlined in brackets:

1. [Complete Agreement.] The terms and provisions of Taylor’s
Order Acknowledgment form constitute the complete and
entire agreement between the parties. NO REPRESENTATIONS,
WARRANTIES(etc...)
2. [Shipping.] Shipments will be F.O.B.: Sellers factory. Unless
definite shipping instructions accompany the order, shipments
will be routed (etc...)

Any suggestions are greatly appreciated.

Thanks!
John

 

[Rick Brandt]

Hi,
I'm using Access 2003 and I need to hardcode "conditions of sale" text into
the report footer of an Access report; the text is about 7,000 characters and
that seems to be too much text for a textbox or a label to hold. What's the
best way to hard code a lot of text onto a report?
Also, the conditions are broken up into about 10 sections each beginning
with a short description of a couple of words which need to be bolded and
underlined. And each section needs to be numbered. An example is shown
below; I placed the text which needs to be bolded and underlined in brackets:

1. [Complete Agreement.] The terms and provisions of Taylor's
Order Acknowledgment form constitute the complete and
entire agreement between the parties. NO REPRESENTATIONS,
WARRANTIES(etc...)
2. [Shipping.] Shipments will be F.O.B.: Sellers factory. Unless
definite shipping instructions accompany the order, shipments
will be routed (etc...)

Any suggestions are greatly appreciated.

Build a table containing the text and descriptions and then a report based on
that table that gives you the desired output of the text and then embed that as
a subreport into your other report.

A TextBox can hold around 64k characters so you have no problem there. In your
table use a text field for the descriptions and memo field for the longer text
entries.

 

[Guest]

Hi,
I'm using Access 2003 and I need to hardcode "conditions of sale" text into
the report footer of an Access report; the text is about 7,000 characters and
that seems to be too much text for a textbox or a label to hold. What's the
best way to hard code a lot of text onto a report?
Also, the conditions are broken up into about 10 sections each beginning
with a short description of a couple of words which need to be bolded and
underlined. And each section needs to be numbered. An example is shown
below; I placed the text which needs to be bolded and underlined in brackets:

1. [Complete Agreement.] The terms and provisions of Taylor's
Order Acknowledgment form constitute the complete and
entire agreement between the parties. NO REPRESENTATIONS,
WARRANTIES(etc...)
2. [Shipping.] Shipments will be F.O.B.: Sellers factory. Unless
definite shipping instructions accompany the order, shipments
will be routed (etc...)

Any suggestions are greatly appreciated.

Build a table containing the text and descriptions and then a report based on
that table that gives you the desired output of the text and then embed that as
a subreport into your other report.

A TextBox can hold around 64k characters so you have no problem there. In your
table use a text field for the descriptions and memo field for the longer text
entries.

That makes sense. I'll probably end up having to look into that solution
but our customer doesn't really care if it's done right they just want it as
quickly and cheaply as possible. Hardcoding it right on the report seems
like the quickest way. So, to your experience and knowledge am I correct in
saying that there's no easy way to hardcode 7,000 characters of text, with
some formatting, into an access report?

Thanks again,
John

 

[Rick Brandt]

That makes sense. I'll probably end up having to look into that solution
but our customer doesn't really care if it's done right they just want it as
quickly and cheaply as possible. Hardcoding it right on the report seems
like the quickest way. So, to your experience and knowledge am I correct in
saying that there's no easy way to hardcode 7,000 characters of text, with
some formatting, into an access report?

See the help topic for the Report's Print method...

Access 97 Help file snippet...

The Print method prints text on a Report object using the current color and
font.
Syntax:
object.Print [{Spc(n) | Tab(n)}][expressionlist][{;|,}]