Field Description for Tables 1

[LonnieJohnson]

Can I programatically get the field description that is typed in for a field when you are in the design view of a table?

I want to use this information while executing a program.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[PHV]

A starting point:
MsgBox CurrentDB.TableDefs("myTable").Fields("myField").Properties("Description")

You may have to play with the On Error Resume Next instruction as the Description property is not required.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[LonnieJohnson]

Man I worked with that in everyway that I could. That is definately what I was looking for.

You are a star in my book.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!