ACC2000: Error When You Type in a List Box That Is Based on a Text Field That Has a Format Character Defined

View products that this article applies to.

This article was previously published under Q248933

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

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

If you press a numeric or an alphabetical key on the keyboard while focus is in a list box that is based on a text field which has a format character defined, you may receive the following error message.

In Windows 95 or Windows 98:

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.

When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:

MSACCESS caused an invalid page fault in module MSACCESS.EXE at 015f:3030df85.

NOTE: The actual memory address may vary.

In Windows NT 4.0:

MSACCESS.EXE - Application Error The instruction at "0x3003436d" referenced memory at "0x039c05d4". The memory could not be "written".

NOTE: The actual addresses in the error may vary.

Back to the top

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 (http://support.microsoft.com/kb/245025/EN-US/ ) OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

Create the following new table:

   Table: Table1
   ---------------------
   Field Name: ID
   Data Type: AutoNumber

   Field Name: F1
   Data Type: Text

Save the table as Table1. Do not add a primary key.
In Datasheet view, type some sample data in the Table1 table, and then close it.
Use the Form wizard to create a new form based on the Table1 table.
View the form in Design view.
Add a list box to the form, and then set the properties of the list box as follows:
RowSource = Table1
ColumnCount = 2
ColumnWidths = 0;1
View the form in Form view. Select any item in the list box, and then press one of the numeric or alphabetical keys on the keyboard (including SPACEBAR). Note that the appropriate item in the list box is selected.
Save the form, and then close it.
View the Table1 table in Design view, and set the Format property of the F1 text field to the all-uppercase format character (>).
Save the table, and then close it.
View the form in Form view. Select any item in the list box, and then press one of the numeric or alphabetical keys on the keyboard (including SPACEBAR). Note that you receive the error message mentioned in the "Symptoms" section.