Capital Letters in a field

[Dbar10]

In Access, there used to be a way to Set the first letter in a field to automatically UpperCase in a form or table to override a lowercase entry. Does anyone know what that is? Thanks

[ChipR]

I know of 2 ways to do this.
One is to put code somewhere to fix what the user entered:

Private Sub Text2_Exit(Cancel As Integer)
    Text2 = StrConv(Text2, vbProperCase)
End Sub

which will capitalize every word, whether you like it or not.

The other is to put an input mask on the field like
>A<CCCCCCCCCCCCCCCC
but that makes the first character (which is required) capitalized, and all subsequent letters (optional) small. It doesn't allow any more capital letters, but it does allow you to set a maximum length by the number of C's you put in.

Here's info on input masks:
http://www.teacherclick.com/access2003/a_5_1_2.htm

[missinglinq]

To capitalize only the first character in a textbox:

Private Sub TextboxName_AfterUpdate()
  Me.TextboxName = UCase(Left(Me.TextboxName, 1)) & Right(Me.TextboxName, Len(Me.TextboxName) - 1)
End Sub

The Exit event should not be used for this kind of thing, it will fire every time the user tabs thru the field. Use the AfterUpdate event instead;it will only fire if the data is entered for the first time or is edited.

Linq ;0)>

[Dbar10]

Thank you ChipR This will work for what I need.