mrrayj60
Registered User.
- Local time
- Today, 17:12
- Joined
- Sep 3, 2009
- Messages
- 103
My form has this after update code. Well my users are adding spaces in the tag number and makes it difficult to sort. They appear as ABC 123 instead of ABC123.
Any suggestions? Thanks, Ray
Me.License_Tag_Number = Trim(UCase(Me.License_Tag_Number))
Thanks, pbaldy
Private Sub License_Tag_Number_AfterUpdate()
Me.License_Tag_Number = Trim(UCase(Me.License_Tag_Number))
Me.License_Tag_Number = Replace(Me.License_Tag_Number, " ", "")
Any suggestions? Thanks, Ray
Me.License_Tag_Number = Trim(UCase(Me.License_Tag_Number))
Thanks, pbaldy
Private Sub License_Tag_Number_AfterUpdate()
Me.License_Tag_Number = Trim(UCase(Me.License_Tag_Number))
Me.License_Tag_Number = Replace(Me.License_Tag_Number, " ", "")
Last edited: