Return a field "description" from a table field 1

[GSMike]

Is there a way to return the description of a field in a table?
I am looking in the object browser for "description", I see nothing. I saw something one time about a person "adding" a property to an object. Is this possible? Is this possible in this case?
For clarification, the description I want is the far right column of a table in design view, where you put a comment to yourself about what the field contains.
Thanks for your help.
Mike Kemp

 

[CPUburn]

Hi GSMike,

there is, indeed, a way but
there is no set property for the description of a field, but you can consult it by field property 25:


Private Sub Form_Load()
Dim db As Database
Dim tbl As TableDef
Dim fld As Field
Dim str_description As String
Set db = CurrentDb
Set tbl = db.TableDefs(1)
Set fld = tbl.Fields(1)

str_description = fld.Properties(25).Value



End Sub