Capitalization

[Mike]

Hi. I have a form where I would like to force
capitalization even if the user enters lower case
letters. Can this be done?

Thanks,
Mike.

 

[tina]

add an event procedure to the control's AfterUpdate event, with the
following code

Me.ControlName = Nz(StrConv(Me.ControlName, vbUpperCase), Null)

this will change the value to all uppercase. to capitalize the first letter
of each word, use vbProperCase instead of vbUpperCase.

hth

 

[Dirk Goldgar]

Hi. I have a form where I would like to force
capitalization even if the user enters lower case
letters. Can this be done?

There are several ways to go about this. The simplest way IMO is to
convert what the user enters in a text box to upper case imediately
after entry is complete, using code in the text box's AfterUpdate event.
The event procedure would look something like this:

Private Sub txtMyTextBox_AfterUpdate()
Me.txtMyTextBox = UCase(Me.txtMyTextBox)
End Sub