[AccessD] DAO field - Description

If there is Description property value then property object exists, if there
is no - it doesn't:

Public Property Get TableFieldDescription( _
                    ByRef rdbs As DAO.Database, _
                    ByVal vstrTblName As String, _
                    ByVal vstrFldName As String) As String
On Error GoTo HandleErr
   With rdbs.TableDefs(vstrTblName).Fields(vstrFldName)
       TableFieldDescription = _
          .Properties("Description").Value
   End With
   Exit Property
HandleErr:
    TableFieldDescription = ""
End Property

Shamil


----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Monday, October 03, 2005 11:00 PM
Subject: [AccessD] DAO field - Description


> When you look at a table in design view, each field has a field name, a
data
> type, and a description.  I have iterated through the field properties of
a
> field in a table, and the various properties I can see are:
>
>
Value;Attributes;CollatingOrder;Type;Name;OrdinalPosition;Size;SourceField;S
>
ourceTable;ValidateOnSet;DataUpdatable;ForeignName;DefaultValue;ValidationRu
>
le;ValidationText;Required;AllowZeroLength;FieldSize;OriginalValue;VisibleVa
> lue;ColumnWidth;ColumnOrder;ColumnHidden;
>
> I am not finding the DESCRIPTION which I REALLY need to extract for
building
> a document.
>
> Does anyone know how I get at the DESCRIPTION property of a field in a
> table?
>
> John W. Colby
> www.ColbyConsulting.com
>
> Contribute your unused CPU cycles to a good cause:
> http://folding.stanford.edu/
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com