[RESOLVED] Programatically read a tables field description

[whiteWay]

In MSAccess, is the a way to programatically read a table's field description?
A quick search of the forum lead me to an unresolved post...so I am left in the dark.

The unresolved post suggested the code (similar):

CurrentDb.TableDefs("SomeTable").Fields(0).Properties("Description").value

But it does not work.

Any suggestions?

[Torc]

If you open your table in design view you will be presented with three columns.

Field Name, Data Type and Description.

The code

Debug.Print CurrentDb.TableDefs("SomeTable").Fields(0).Properties("Description").value

Will give give the Description field of the first field of SomeTable.
If it gives nothing then that probably means that the Descritpion field for that
Table field is blank.

To test this put some text in the Description field and run the code again.

[whiteWay]

Thanks.

The statement is bailing out because it is empy.

If the description is empty, I expected an empty string or null to be returned by the statement....but it looks like does not.

Thanks again.