convert text to capitals

[AyseG]

I would like to have a field convert the text typed to all capitals

 

[Dirk Goldgar]

I would like to have a field convert the text typed to all capitals

The simplest way is have a procedure for the AfterUpdate event of the
text box. For example,

Private Sub txtMyTextBox_AfterUpdate()

With Me!txtMyTextBox
.Value = UCase(.Value)
End With

End Sub