Microsoft KB Archive/248933
Article ID: 248933
Article Last Modified on 11/25/2002
- Microsoft Access 2000 Standard Edition
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).
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:
When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:
NOTE: The actual memory address may vary.
In Windows NT 4.0:
NOTE: The actual addresses in the error may vary.
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)
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.
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.
Additional query words: pra msaccess exe
Keywords: kbbug KB248933