How to access Access database table info
David uses the same method as I do
but I use On Error goto HasError
In HasError I check for the right error-number (property not found)
If so I put de fieldname in the Descript variable
then resume next
Using this way the Descript Variable is always filled with something
(if not the description then the fieldname)
David J. Linden heeft geschreven in bericht ...
Quote:
>Here's how I do it:
>----------------------------------------
>Private Function Descript$(f As Field)
> On Error Resume Next
> Descript = f.Properties!Description
>End Function
>----------------------------------------
>The "On Error" is necessary because you'll get an error if the field has no
>description.
