Microsoft KB Archive/295270

= ACC2002: Access Quits When Previewing Report Created from Form =

Article ID: 295270

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295270



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you preview a report created by saving a form as a report, you may receive the following error message:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.



CAUSE
This behavior can occur when the form on which the report is based has ActiveX-bound controls and the report is longer than one page. Access quits when you try to select the second page. Note that there is no data loss and the behavior occurs only once.



RESOLUTION
To prevent Access from quitting unexpectedly, close your database before you preview the report, and then open it again. This issue does not occur when you preview the report after you reopen the database.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Problem
 Start Microsoft Access and create a new database, ReportTest.mdb.  Create a new table in ReportTest.mdb:   Table: Table1 --  Field Name: MyDate Data Type: Date/Time   Add the following records to Table1:   Date 01/01/01  01/02/01   01/03/01   01/04/01   01/05/01   01/06/01                      Create the following form: <pre class="fixed_text">  Form: Form1 --  RecordSource: Table1

Text box --  Name: MyDate ControlSource: MyDate

Calendar Control -  Name: Calendar1 ControlSource: MyDate </li> Save and close Form1.</li> In the Database window, select Form1.</li> On the File menu, click Save As.</li> In the Save As dialog box, select Report in the As list, and then click OK.</li> In the Database window, click Reports.</li> Select the report that you saved in step 8, and then click Preview.</li> On the Record Selector, click Next. Note that Access quits and you receive the error message listed in the &quot;Symptoms&quot; section of this article. This behavior occurs only once for a given report.</li></ol>

Additional query words: pra

Keywords: kberrmsg kbbug KB295270

-

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

© Microsoft Corporation. All rights reserved.