List Fields ListFields() Part 3: Field Details In part 3, we add an optional parameter to the ListFields() function to display the field details in the immediate window.
List Fields ListFields() Part 2: An Optional Prefix The ListFields() routine expands to include optional table/alias prefixes for outputting fully qualified field names.
List Fields ListFields() Part 1: Listing Table Fields in the Immediate Window An easy way to reduce context switching between the VBA IDE and the Access application window is to list table field names in the immediate window.