DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 170144 - Last Review: October 7, 2013 - Revision: 3.1

 
This article was previously published under Q170144
This article has been archived. It is offered "as is" and will no longer be updated.
Advanced: Requires expert coding, interoperability, and multiuser skills.

On This Page

SYMPTOMS

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.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Access 2000.

MORE INFORMATION

Steps to Reproduce Problem

  1. Start Microsoft Access 97 and open any database.
  2. Create a new form not based on any table or query in Design view.
  3. On the Tools Menu, click Options.
  4. In the Options dialog box, select the Modules tab. Make sure that the Auto List Members check box is selected, and then click OK.
  5. On the View menu, click Code.
  6. 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.
  7. Complete the last line of code so that it reads as follows:
    Dim x as TestType
    					
  8. Compile the code. Note that you can compile the code successfully.

REFERENCES

For more information about user-defined data types, search the Help Index for "Type Statement."

APPLIES TO
  • Microsoft Access 97 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbprogramming KB170144
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support