Previously I asked about how to enumerate valid choices or enumerations for properties. Danaseaman provided a good answer that worked, as follows: "Assuming you know the name of the Enum, add a reference to TlbInf32.Dll and use Public Function GetEnumNames" (which code he provided).
That question can be found at: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22455539.html
Now for part 2. I opened tlbInf32.dll in the Object Browser, and it looks like it would be possible to loop through the controls (both activeX and native Access controls) on a form, get the names of the properties, and the range or list of valid values, withot having to know the enum name first, that is, retrieve the class names of TKIND_ENUM and also the alias or property names that you would find in the property sheet. What I want to do is have a data grid with the property name in the first column (e.g., DayOfWeek), the enum name in the second column (e.g., enumDayOfWeek), and the enumerated values (e.g., 1,2,3,4,5,6,7, each on a separate row). THe link above has the code that is a starting point.