Make Default upper case

[stu_c]

is there a way to make fields default to uppercase? if how please help i cannot seem to find it in the properties box

 

[MStef]

In "Format" properties put the sign > (in the form, or in the table, or in both). For text fields only.

 

[sphynx]

Below is code attached to convert text to uppercase automatically on entry by user.

Just change (Your Control Name) to the name of your text box

Private Sub (Your Control Name)_KeyPress(KeyAscii As Integer)
    Dim strCharacter As String

    ' Convert ANSI value to character string.
    strCharacter = Chr(KeyAscii)
    ' Convert character to upper case, then to ANSI value.
    KeyAscii = Asc(UCase(strCharacter))
End Sub