What Reference Is Needed?

[Guest]

Using Access 2003 I am trying to write code to modify a control's property.
However, when I type the syntax of "Me!FieldName." the properties in the
dropdown for that field is not shown like visible or height. What reference
an I not checking? So far i have checked:
Visual Basic For Applications
Microsoft Access 11.0 object Library
Microsoft Office 11.0 Object Library
Microsoft DAO 3.6 Object Library

Thanks!

 

[Guest]

I'm no pro, but I have found when this occurs something is usually knotted up
in memory. Compact and Repair, close the DB and reopen. This has worked for
me before. Also, be sure you are in a class module or the ME syntax won't
work...of course none of this may work for you, but HTH any how.

 

[David W. Fenton]

Using Access 2003 I am trying to write code to modify a control's
property. However, when I type the syntax of "Me!FieldName." the
properties in the dropdown for that field is not shown like
visible or height. What reference an I not checking? So far i have
checked:

Visual Basic For Applications
Microsoft Access 11.0 object Library
Microsoft Office 11.0 Object Library
Microsoft DAO 3.6 Object Library

I'd try removing the Office 11 library and compiling the project to
see if it still compiles. If it does, you don't need it.

Sometimes you can force a form of Intellisense by hitting Ctrl-Space
on the keyboard (but it's a longer list than you get with normal
Intellisense; it will still Autocomplete like regular Intellisense).
You should also try Me.FieldName to see if it gives the properties.

Last of all, if you have a field in your recordsource that has the
same name as your control, then that could be the source of the
problem. How could Access know whether you want to
properties/methods for the field in the recordsource or for the
control if you've given them the same name?

My rule is that any control that is referenced in code must have its
name changed so that it isn't the same as the ControlSource value.

 

[Guest]

BTW, the only other item I have checked is: OLE Automation