In the property sheet for Queries and Tables there is a description property that VBA can get to through the querydef and tabledef.
In table design you can list a description for each field that VBA can get to through the field properties.
For forms and reports, you right click on the object and can enter a description. VBA can get these through the Containers/Documents/Properties/Description.

My question is, where can I put a description for a form control (list box, cmd button, cbo box, etc.) that VBA can get to?

Why? I'm putting documentation in these description properties and using VBA to generate a report like the database documentor but that is much more useful to me and anyone unlucky enough to deal with my database after me.

Thanks in advance!
Cori

Hi Cori,

I admire your efforts. That's a very noble approach.

Could you use the Tag property? How about the Control Tip property?

Just my 2 cents...

Don't know about noble, but it's a lot easier than the approach I had back when I thought I knew what I was doing.

At least now I know I don't have a clue.

Control Tip hovers over the control. I want to use that for the users. The "description" I want would be more technical than I'd want them to see.
Don't know anything about the Tag - will do some research.

Thanks for the help!

Cori

Hi Cori,

If you are not familiar with the tag property, then it's probably a good candidate for what you need because it would mean that you're not using it for anything else. Besides the Caption and Control Tip properties, the Tag property is the only other property where you could put a text value and it would be harmless.

Just my 2 cents...

Took a look and it's just what I need.

It's much easier for me to add descriptions for tables, fields, queries, forms, controls, reports, modules, functions as I'm building them rather than go back and try to remember what in the world the thing was for.

The tag will really help - Thanks!!

Hi Cori,



Glad to hear you will be able to use it. The Tag property is a multi-purpose property. You can use it for many things.

Good luck with your project.