Form description (1 Viewer)

[drakopp]

I apologize in advance for my English.
Tell me, please, how to set a description for a form using vba?

 

[Ranman256]

if in the form:
me.description = "new description"

from another form:
forms!fMyForm.description = "new description"

tho why would you need to in VB?

 

[drakopp]

if in the form:
me.description = "new description"

from another form:
forms!fMyForm.description = "new description"

tho why would you need to in VB?

In MS Access, there is no such property for a form

 

[Gasman]

.Caption perhaps?

 

[drakopp]

.Caption perhaps?

No, the description interests

 

[jdraw]

Please tell us more of the context. If you maintain a database of your database objects, then I would expect a table with fields for ObjName, ObjType, ObjDescription.... that you would maintain.
You can use the built in feature by right-clicking the Form, ViewProperties and fill in the Description box that is presented.

 

[isladogs]

If you create a form description manually then use the database documenter, you will see the Description property listed
However, using VBA, the Description property has to be created first before it can be populated.

Although I've never tried to do this, Allen Browne has code that I believe should do what you want.
Seethe SetPropertyDAO function at http://allenbrowne.com/func-DAO.html#SetPropertyDAO

Alternatively, see if you can adapt the code from this old AWF thread - post #4 contains code that may help

VBA to set Form properties when the form opens

What I am trying to do is create a VBA Function which takes a form as a parameter and then sets certain properties on that form, which Im thinking could either be run on the Form Open event or when actually opening the form (so creating another function which performs the property updates and...

www.access-programmers.co.uk

Let us know how you get on