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



The information in this article applies to:

  • Microsoft Access 2000

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.

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 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create the following new table:
       Table: Table1
       ---------------------
       Field Name: ID
       Data Type: AutoNumber
    
       Field Name: F1
       Data Type: Text
    					
  2. Save the table as Table1. Do not add a primary key.
  3. In Datasheet view, type some sample data in the Table1 table, and then close it.
  4. Use the Form wizard to create a new form based on the Table1 table.
  5. View the form in Design view.
  6. 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

  7. 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.
  8. Save the form, and then close it.
  9. View the Table1 table in Design view, and set the Format property of the F1 text field to the all-uppercase format character (>).
  10. Save the table, and then close it.
  11. 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.

Modification Type:MajorLast Reviewed:11/25/2002
Keywords:kbbug KB248933