VBA Editor hides some proporties

R

Razor

Hi,

Why does the VBA Editor hide some properties when the dot
is typed by the programmer?

If a hidden property is typed anyway followed by Enter,
the VBEditor capitalizes it, so it must recognize it.

I'm wondering why it doesn't show it in the first place?

Thanks!

Regards,
Razor
 
K

Kevin K. Sullivan

Go to the Object Browser (F2)
Right-click...
Choose Show Hidden Members

This reveals vital stuff such as Application.SaveAsText and
Application.LoadFromText
I consider hidden members to be undocumented and use-at-your-own-risk.

Don't count on autoapitalization to indicate valid syntax, though.
----------
Dim f as Form

Debug.Print f.connection ' will be changed to f.Connection
----------
This capitalization takes place because there is a Connection object defined
in DAO and ADODB, not because Connection is a valid member of the Form
object (it isn't). It won't be caught until run time.

HTH,

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top