TextBox6.Text = UCase(TextBox6.Text)

Thanks Dave

"Dave Peterson" wrote:

with textbox6
.text = ucase(.text)
end with

VBA doesn't have a Proper function, so lots of people use:
application.proper(). But lcase() and ucase() both exist.

And you may want to look at strconv(), too.

It's another way to do string conversions.

Jim at Eagle wrote:

I need to properly display the state code in upper case.
Any suggestions?
--
Jim at Eagle

--

Dave Peterson