Find values of Field properties

[Brent]

Hi All

Can anyone tell me if it's possible to find the values of
field properties using VBA? For example, I want to find
the "description" of a field in a table using VBA. Then
I would like to take a portion of that description and
populate the "Caption" property.

I noticed that these properties weren't part of
the "Fields" collection.

Any help would be great, Thanks in advance!!

 

[Allen Browne]

This example shows how to loop through the fields of a table to read the
Description property:
http://allenbrowne.com/func-06.html

The basic idea is:
dbEngine(0)(0).TableDefs("MyTable").Fields("SomeField").Properties("Descript
ion")

However, the Description property does not exist for fields that have no
description, so you need error handling.