Capital letters

a.mlw.walker

Registered User.
Local time
Today, 20:26
Joined
Jun 20, 2007
Messages
36
Hi, I have an address database and in the zipcode/postcode box, i want all letters entered to go to capitals ie rj20 4ls would go to RJ20 4LS after update. how could i do this, what do i add to text boxes after updat?
Thanks

Alex
 
Private Sub Form_AfterUpdate()

On Error Resume Next
With Me
If StrComp(UCase(!MyFieldName), _
!MyFieldName, vbBinaryCompare) <> 0 Then

!MyFieldName = UCase(!MyFieldName)
End If
End with
End Sub
 
Last edited:

Users who are viewing this thread

Back
Top Bottom