ACC2: Output to RTF Not Processed in Report with Memo Fields
ID: Q131019
|
The information in this article applies to:
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
When you use the Output To command to output a report containing Memo
fields to a Rich Text Format (RTF) file, the RTF file is not created.
Microsoft Access does not alert you that the command was not processed.
CAUSE
The problem occurs when any one of the following conditions is true for the
report:
- When you print the report, a Memo field's data spans multiple pages.
- The report contains two or more large Memo fields.
- The table, query, or SQL statement on which the report is based
generates large Memo fields.
RESOLUTION
To work around the problem, design the report as follows:
- Limit the data that will appear in a Memo field so that it fits
on one page.
- Reduce the number of records generated by the table, query, or SQL
statement on which the report is based.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access
version 2.0. This problem no longer occurs in Microsoft Access
version 7.0.
MORE INFORMATIONSteps to Reproduce Problem
- In your Access directory in File Manager, double-click the
CONSTANT.TXT file to open the file in Notepad.
- From the Edit menu, choose Select All. Then, from the Edit menu,
choose Copy, and exit Notepad.
- Start (or switch to) Microsoft Access and create a database called
MEMOTEST.MDB.
- Create the following table and save it as Memo_Test:
Table: Memo_Test
-------------------------------
Field Name: ID
Data Type: Counter
Indexed: Yes (No Duplicates)
Field Name: Test
Data Type: Memo
- View the Memo_Test table in Datasheet view.
- In the first record, move the insertion point to the Test field box.
- From the Edit menu, choose Paste to copy the CONSTANT.TXT file to the
Test field box.
- Repeat step 7, and then close the Memo_Test table.
- Click the AutoReport button on the toolbar to create a quick report
based on the Memo_Test table and save it as Report1.
- From the File menu, choose Output To.
- In the Select Format box, select Rich Text Format (*.rtf), and then
choose the OK button.
- In the File Name box, type memotest.rtf, and then choose OK.
- Switch to File Manager and search for the MEMOTEST.RTF file. Note that
the file is not listed.
REFERENCES
For more information about the Output To command, search for "Output To"
then "Output To Command (File Menu)" using the Microsoft Access Help
menu.
Keywords : kbusage OtpRtf
Version : 2.0
Platform : WINDOWS
Issue type : kbbug
|