This report shows for each Microsoft Access table's field, the property names and values that appear on the Lookup tab of the table designer when editing the field definition:
Microsoft Access Table Designer Field Lookup tab
These properties exist if the field is defined as a CheckBox or ComboBox.
Use this report as a quick way to see all the top level properties across all the fields in a table in one place. Easily see the row source, bound column, column count, LimitToList, display settings, and other properties of all the combo boxes on your fields.
This eliminates the need to manually click on each field to first see which ones are combo boxes, and then review the ones you find.
Here's the complete list of the Total Access Analyzer reports documenting the tables in your MS Access database. Click on the hyperlinks for more information. Rather than overwhelm you with every report, we've provided a subset of the most interesting reports for you to review. The others show similar data but use different sort orders or filters.
Simple lists to gain a quick understanding of all the tables in your database and their relative size
Examine fields lists for each table, or for each field which tables its in, along with their properties
Look at all the properties of a field the way you would in the table designer or see a property value across all the fields that have them.
Examine indexes and their fields and properties
Detailed listing of each table, its properties, indexes, fields, etc.
Version 16.7 for
Microsoft Access 2016
Version 15.7 for
Microsoft Access 2013
Version 14.7 for
Microsoft Access 2010
Version 12.97 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 for
Access 2002 and 2000
"Total Access Analyzer is an amazing product that I've relied on and recommended for years. It's a huge time saver."
Sal Ricciardi, Programming Writer, Microsoft Corporation