Using VBA to access field.descriptions

[Robin Ball]

I have a partially developed database docementation system

Within that I wish to extract the contents of field descriptions to a table
of field names.

The online help shows that field descriptions are specific to Access,
effectively a user defined property.

The Online help is obscure about how and what to append the description
property to to enable reading / writing values using VBA

Any help would be much appreciated

T I A

Robin Ball

 

[Allen Browne]

For an example of how to read the field descriptions, see:
http://allenbrowne.com/func-06.html

If the Description does next exist, you need to CreateProperty().

 

[Robin Ball]

Thanks Allen

Your code helped me do what I had been trying to do all day. The Access
help files goes on about having to create the description property to make
the reference work.

Your special function using the syntax obj.Properties("Description") did the
trick in less than a line of code.

Many thanks

Robin Ball

UK