Whole Entry In CAPS

[Wilse]

Hi guys, me once more with a silly question.

I used a Ucase code to turn the text in my textbox to CAPs using the After Update Event.

This was working fine but now it send me to debug the code.

Is there a simple way or do you guys know the best code to use for this to work?

Many Thanks

 

[vbaInet]

Ucase() is the function you need, although there's another.

Could you please paste the particular sub routine here. Also highlight the line of code where it's pointing at.

 

[Wilse]

Private Sub Product_Code_AfterUpdate()
Me.ActiveControl = UCase(Me.ActiveControl)
End Sub

 

[Wilse]

Oh and thanks for that last night, works like a dream now

 

[vbaInet]

Something is missing in your syntax. Is there a particular control you want to make Upper Case or there are a few controls?

You can use this symbol > in your table to make it display as upper case if you wanted to?

Oh and thanks for that last night, works like a dream now

No worries Wilse. You're welcome.

 

[ghudson]

YourTextBox = UCase(YourTextBox)

 

[Wilse]

cheers guys works great