• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1085
  • Last Modified:

MS ACCESS 2007 Printing Table Field Descriptions

IN ACCESS, you can enter a description for each field in a table in the TABLE>DESIGN VIEW>  However, there soes not appear to be anyway to print out this view. It would be great user documentation to be able to print out the table design view as it would show the field name, data type, and Description.  None of the options in the database documentor or reports has the description.  
1 Solution
Rey Obrero (Capricorn1)Commented:
try this codes

Sub getFieldDescription()
On Error Resume Next
Dim tbl As dao.TableDef
Dim fld As dao.Field
Open "C:\myFieldDesc.txt" For Output As #1
    For Each tbl In CurrentDb.TableDefs
        For Each fld In tbl.Fields
           Print #1, tbl.Name & " > " & fld.Name & " > " & fld.Properties("Description")
        Next fld
    Next tbl

Close #1
End Sub

that will create a text file  myFieldDesc.txt in C"\
gracelandDBAuthor Commented:
Outstanding.... I do not see how Microsoft could not have realized the need to print out a table field listing with the self documenting descriptions.

THanks again

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now