table field descriptions

  • Thread starter Thread starter Ken Pinard
  • Start date Start date
K

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
 
You can add field descriptions in the table designer for each field and use
the table properties description section to describe the table.

Dan
 
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
 
Back
Top