Textbox = Capital letters ?
 

TextBox2.ControlSource = UCase(Value) ' not working

I get no error but i also get no Capitals.
How to set the Textbox2 to be ALWAYS Capitals?
Corey....

Textbox = Capital letters ?
 

Thants where it is now but no workies:

Private Sub TextBox2_Change()
TextBox2.ControlSource = UCase(Value)
End Sub

Corey....
"Tom Ogilvy" wrote in message
...
Use the change event to make the entry uppercase.

--
Regards,
Tom Ogilvy


"Corey" wrote:

TextBox2.ControlSource = UCase(Value) ' not working

I get no error but i also get no Capitals.
How to set the Textbox2 to be ALWAYS Capitals?
Corey....

Textbox = Capital letters ?
 

Thanks Tom.
Spot on.
"Tom Ogilvy" wrote in message
...
textbox2.value = Ucase(Textbox2.Value)

not controlsource and not value.

--
Regards,
Tom Ogilvy


"Corey" wrote:

Thants where it is now but no workies:

Private Sub TextBox2_Change()
TextBox2.ControlSource = UCase(Value)
End Sub

Corey....
"Tom Ogilvy" wrote in message
...
Use the change event to make the entry uppercase.

--
Regards,
Tom Ogilvy


"Corey" wrote:

TextBox2.ControlSource = UCase(Value) ' not working

I get no error but i also get no Capitals.
How to set the Textbox2 to be ALWAYS Capitals?
Corey....