Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103999

From BetaArchive Wiki

ACC1x: GP Fault Referencing Column Property of Combo Box

Q103999



The information in this article applies to:


  • Microsoft Access 1.1





SYMPTOMS

The following messages will appear when you are trying to reference the Column property of a combo box in Datasheet view:


  • An error has occurred in your application. If you choose Ignore, you should save your work in a new file. If you choose Close, your application will terminate
  • Application Error: Microsoft Access caused a General Protection Fault in module MSAIN110.DLL



CAUSE

The general protection (GP) fault will occur under the following conditions:


  • The combo box has a query or table as the RowSource.
  • The form must be opened directly into Datasheet view.
  • A selection has been made in the combo box.
  • The Column property of the combo box is referenced in an expression.



RESOLUTION

The following methods can be used to work around the problem:

Method 1

If the form will only be used in Datasheet view, use a list box instead of a combo box. A list box is functionally equivalent to a combo box in Datasheet view.

Method 2

If the form will be used in both Datasheet view and Form view, make sure the form is opened in Form view first. The following macro can be used to open the form in Form view, then in Datasheet view:


   Action    Described Below
   -------------------------

   Echo            1
   OpenForm        2
   OpenForm        3
   Echo            4

   Macro Actions
   -------------

   1. Echo
         Echo On: No
   2. OpenForm
         Form Name: MyForm
         View: Form
   3. OpenForm
         Form Name: <your form name here>
         View: Datasheet
   4. Echo
         Echo On: Yes 



STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.1. This problem no longer occurs in Microsoft Access version 2.0.



MORE INFORMATION

Steps to Reproduce Problem



  1. Open the sample database NWIND.MDB in Microsoft Access version 1.1.
  2. Create a blank, unbound, form with the following form properties:


DefaultView: Datasheet

  1. Create a combo box on the form with the following properties:


ControlName: MyCombo
RowSourceType: Table/Query
RowSource: Employees
ColumnCount: 2

  1. Close and save the form with the name "MyForm".
  2. Open the form from the Database window and make a selection in the combo box.
  3. With the form left open, create a new module.
  4. From the View menu, choose Immediate window.
  5. Type the following, and then press ENTER:


? Forms!MyForm!MyCombo.Column(1)

Additional query words: combo box list box GPF

Keywords : kbusage
Issue type : kbbug
Technology :


Last Reviewed: November 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.