Microsoft KB Archive/148298

= ACC2: "Publish It With MS Word" Loses CanShrink Formatting =

Article ID: 148298

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q148298



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you use the "Publish It With MS Word" button for a report or use the Output To command on the File menu to output the report as a Rich Text Format (.rtf) file, the report does not retain the CanShrink property formatting of the report.



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.



Steps to Reproduce Behavior
  Open any database. Create a new table with the following two fields:

     Field Name: State Data Type: Text Field Name: City Data Type: Text

Save the table as tblPublishIt. Do not create a primary key.  View the tblPublishIt table in Datasheet view and type 10 records with WA in the State field and 10 different cities of your choice in the City field. Type 1 record with TX in the State field and 1 city of your choice in the City field. Type 10 records with NC in the State field and 10 cities of your choice in the City field. Save and then close the tblPublishIt table. Create a new report based on the tblPublishIt table by using the Groups/Totals Wizard. When prompted, move the State field and the City field form the Available fields box to the Field Order On Report box and click Next. Move the State field from the Available fields box to the Group Records By box, and click Finish. Save the report as rptPublishIt.</li>  Open the rptPublishIt report in Design view. Drag the State field from the State header to the detail section so that it is even with the City field. Set the properties for the State field as follows:

<pre class="fixed_text">     Height: 1 inch CanShrink: Yes </li> Set the detail section's CanShrink property to Yes.</li> Preview the rptPublishIt report and note that the CanShrink property behaves as expected.</li> Click the "Publish It With Microsoft Word" button or click the Output To command on the File menu to output the report to Rich Text Format. Note that when Microsoft Word loads the document, the distance between rows in the document is the same as the Height property setting of the State text box.</li></ol>

Additional query words: Output to

Keywords: kbbug kbfix kbinterop KB148298

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.