View Single Post
  #1  
Old June 1st, 2010, 10:41 AM posted to microsoft.public.access
jamccarley
external usenet poster
 
Posts: 54
Default 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