Be aware, though, that the Description property doesn't exist unless you've
defined a description. Therefore, that code will raise an error for any
tables/fields that don't have a description. Trap the error and issue a
Resume Next and you should be fine.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"polite person" <si*****@pc.com> wrote in message
news:43****************@news.easynews.com...
On 24 Aug 2005 04:30:58 -0700, "mawi" <ts*****@swissinfo.org> wrote:
I'd like to copy the comment column from a access-table into the
clipboard (or export it anyhow). any suggestions? cheers. mw
Hi
if you want the description property of the table you get it by code
like
CurrentDb.TableDefs("YourTableName").Properties("D escription")
or for a field, code like
CurrentDb.TableDefs("YourTableName").Fields("YourF ieldName").Properties("Description")
(which you would write more sensibly in a loop)
Is this what you are after?
David