'以下是得到描述信息的,若需要得到字段的名字、类型,可以用rs("FieldName").Name,rs("FieldName").Type得到
Function GetFieldDesc_ADO(ByVal MyTableName As String, _
ByVal MyFieldName As String)
Dim MyDB As New ADOX.Catalog
Dim MyTable As ADOX.Table
Dim MyField As ADOX.Column
On Error GoTo Err_GetFieldDescription
MyDB.ActiveConnection = CurrentProject.Connection
Set MyTable = MyDB.Tables(MyTableName)
GetFieldDesc_ADO = MyTable.Columns(MyFieldName).Properties("Description")
select value from sysproperties WHERE id in (select id from sysobjects where name ='YourTableName') and smallid in (select colid from syscolumns where name ='YourColumnName') and name='MS_Description'