table field descriptions

[Ken Pinard]

I would like to create field descriptions in my tables. I can't seem to find
the correct method/property to do this. Can some one please point me in the
correct direction to find out how descriptions to fields (table descriptions
would be nice too)


TIA

Ken Pinard

 

[solex]

You can add field descriptions in the table designer for each field and use
the table properties description section to describe the table.

Dan

 

[Ken Pinard]

I am sorry, I was typing behind my thought pattern. I want to do this all
code using the createfield method, createproperites, etc.

What i figured out was that the Description properties don't exist until
they are set some how. This adds a description if it does not exit.

Thank you,

Ken

For Each fld In tdf.Fields


Debug.Print "Field Property: " & fld.Name & " Property: ";
fld.Properties("Description").Name & ": " &
fld.Properties("Description").Value
If Err.Number <> 0 Then
Debug.Print Err.Number & " " & Err.Description
Err.Clear
Set prp = fld.CreateProperty("Description", dbText, "Add
one")
fld.Properties.Append prp
If Err.Number <> 0 Then
Debug.Print " After add property: " & Err.Number & " " &
Err.Description
Err.Clear
End If

End If


Next fld