If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compile error- Invalid use of property
I am using a simple code to change everthing in the field to CAPS. For some
reason all of my fields work except one. The code is the same as all of the others, ecept it gives a "Compile error- Invalid use of property" error. Here is the code. Private Sub Controls_AfterUpdate() On Error GoTo Err_Controls_AfterUpdate Me.Controls = UCase(Me.Controls) End Sub Err_Controls_AfterUpdate MsgBox Err.Description Resume Exit_Controls_AfterUpdate End Sub |
#2
|
|||
|
|||
Compile error- Invalid use of property
Rename the control. Controls is a reserved word (all forms and reports have
a Controls collection associated with them) For a comprehensive list of names to avoid (as well as a link to a free utility to check your application for compliance), see what Allen Browne has at http://www.allenbrowne.com/Ap****ueBadWord.html -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele Co-author: Access 2010 Solutions, published by Wiley (no e-mails, please!) "jamccarley" wrote in message news I am using a simple code to change everthing in the field to CAPS. For some reason all of my fields work except one. The code is the same as all of the others, ecept it gives a "Compile error- Invalid use of property" error. Here is the code. Private Sub Controls_AfterUpdate() On Error GoTo Err_Controls_AfterUpdate Me.Controls = UCase(Me.Controls) End Sub Err_Controls_AfterUpdate MsgBox Err.Description Resume Exit_Controls_AfterUpdate End Sub |
#3
|
|||
|
|||
Compile error- Invalid use of property
That worked great. Thanks
"Douglas J. Steele" wrote: Rename the control. Controls is a reserved word (all forms and reports have a Controls collection associated with them) For a comprehensive list of names to avoid (as well as a link to a free utility to check your application for compliance), see what Allen Browne has at http://www.allenbrowne.com/Ap****ueBadWord.html -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele Co-author: Access 2010 Solutions, published by Wiley (no e-mails, please!) "jamccarley" wrote in message news I am using a simple code to change everthing in the field to CAPS. For some reason all of my fields work except one. The code is the same as all of the others, ecept it gives a "Compile error- Invalid use of property" error. Here is the code. Private Sub Controls_AfterUpdate() On Error GoTo Err_Controls_AfterUpdate Me.Controls = UCase(Me.Controls) End Sub Err_Controls_AfterUpdate MsgBox Err.Description Resume Exit_Controls_AfterUpdate End Sub . |
Thread Tools | |
Display Modes | |
|
|