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


.