Microsoft KB Archive/170144
Article ID: 170144
Article Last Modified on 1/20/2007
- Microsoft Access 97 Standard Edition
This article was previously published under Q170144
Advanced: Requires expert coding, interoperability, and multiuser skills.
A private, user-defined data type declared in a class module does not appear in the Auto List Members box as expected. However, a private, user-defined data type does appear in the Object Browser when you select the project name from the list of Libraries.
This problem does not occur with a user-defined data type declared in a standard module.
Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Access 2000.
Steps to Reproduce Problem
- Start Microsoft Access 97 and open any database.
- Create a new form not based on any table or query in Design view.
- On the Tools Menu, click Options.
- In the Options dialog box, select the Modules tab. Make sure that the Auto List Members check box is selected, and then click OK.
- On the View menu, click Code.
Type the following code:
Private Type TestType strTestType As String End Type Dim x As
Note that TestType does not appear in the Auto List Members box.
Complete the last line of code so that it reads as follows:
Dim x as TestType
- Compile the code. Note that you can compile the code successfully.
For more information about user-defined data types, search the Help Index for "Type Statement."
Keywords: kbbug kbprogramming KB170144