ACC2002: Access Quits When Previewing Report Created from Form (295270)

Microsoft Access 2002

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.

MORE INFORMATION

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:

   Form: Form1
   ----------------------
   RecordSource: Table1

   Text box
   ----------------------
   Name: MyDate
   ControlSource: MyDate

   Calendar Control
   ---------------------------------
   Name: Calendar1
   ControlSource: MyDate

Save and close Form1.
In the Database window, select Form1.
On the File menu, click Save As.
In the Save As dialog box, select Report in the As list, and then click OK.
In the Database window, click Reports.
Select the report that you saved in step 8, and then click Preview.
On the Record Selector, click Next. Note that Access quits and you receive the error message listed in the "Symptoms" section of this article. This behavior occurs only once for a given report.

Modification Type:

Major

Last Reviewed:

11/5/2003

Keywords:

kbbug kberrmsg KB295270