> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Quickly List the Properties of an Object in Access
- URL: https://nolongerset.com/list-properties/
- Published: 2021-08-24T02:43:32.000Z
- Updated: 2026-05-08T13:02:47.000Z
- Description: Here's a quick and dirty procedure to iterate through an Access object's Properties collection.
- Author: Mike Wolfe
- Tags: Code Library, #DesignProcedures, Debugging, #Import 2026-05-20 02:59

Many objects in the Office object model include a `Properties` collection, including the following objects in Microsoft Access:

- Database
- Form
- Report
- QueryDef
- Control

Here's a quick routine that loops through an object's Properties collection, outputting the index, name, and value of each property to the immediate window. This is a handy debugging tool.

## The Code

```vba
Public Sub ListProperties(obj As Object)
    Dim i As Long
    For i = 0 To obj.Properties.Count - 1
        On Error Resume Next
        Debug.Print Right("   " & i, 4); " ";
        Debug.Print Left(obj.Properties(i).Name & Space(30), 30); " ";
        Debug.Print obj.Properties(i).Value;
        
        'print a blank line every three rows to improve readability
        If i Mod 3 = 2 Then Debug.Print
        Debug.Print
        
        'pause the output after every 50 properties 
        '    as a quick and dirty form of pagination
        If i Mod 50 = 49 Then Stop  'press F5 to continue
    Next i
End Sub
```

Here's a sample usage:

![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/08/image-48.png)

This is just the first nine properties of my current database object (there were 50 total).

*Image by [Nile](https://pixabay.com/users/nile-598962/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=623167) from [Pixabay](https://pixabay.com/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=623167)*