obtaining the field "Description"

[Disco Octopus]

Hi,

Is it possible to obtain the description of a field in MS Access... using
SQL or within the query, or (preferebly) using VB.

Thanks

 

[Allen Browne]

Try:

CurrentDb().TableDefs("MyTable").Fields("MyField").Properties("Description")
Generates error 3270 if there is no description.

Example of looping through a table to get fields and descriptions:
http://allenbrowne.com/func-06.html