Find values of Field properties

  • Thread starter Thread starter Brent
  • Start date Start date
B

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!!
 
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.
 
Back
Top