capitalize

O

Ofer Cohen

Is that the name of the text box in the form?

can you post the full code from the after update event of the text box,
include the

Sub SubName()
code
End Sub
 
A

Allen Browne

Use UCase() in the AfterUpdate event of the control.

To just display the values in all caps, you can set the Format property of
the text box to:But that has some side effects:
- The stored value is not capitalized, so you get wrong results in a mail
merge.
- If you use this on a memo, the text is truncated.
 
Top