VBA Editor hides some proporties

  • Thread starter Thread starter Razor
  • Start date Start date
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
 
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
 
Back
Top