force inputbox to uppercase

  • Thread starter Thread starter Hermie
  • Start date Start date
H

Hermie

Hello
I created a textbox in the reportheader with an inputbox. Now I want the
text entered in the inputbox always shows in uppercase even when you type in
lowercase.
I change the format property of the textbox to > But this not changes the
text entered in the inputbox. How can I force the inputbox to show the text
in uppercase?
The rowsource of the textbox is:
="Some text here " & inputbox("entre month and year", "textbox") & " Some
text there"

Hope someone can help me

Herman
 
Hermie said:
Hello
I created a textbox in the reportheader with an inputbox. Now I want
the text entered in the inputbox always shows in uppercase even when
you type in lowercase.
I change the format property of the textbox to > But this not changes
the text entered in the inputbox. How can I force the inputbox to
show the text in uppercase?
The rowsource of the textbox is:
="Some text here " & inputbox("entre month and year", "textbox") & "
Some text there"

Hope someone can help me
Click to expand...


="Some text here " & UCase(inputbox("entre month and year", "textbox")) & "Some
text there"
 
Hello Rick

That works,
I put Ucase inside the inputbox but it must be placed before it

herman
 
Back
Top