Change a field to upper case

O

Ofer Cohen

Using UCase

UCase([FieldName])

Or
StrConv([FieldName],1)

will make it all to upper case.
Also, check help on the function StrConv to see the different options
 
O

Ofer Cohen

Also, just rememberd

Putting > in the format property of the text box will make it UpperCase
 
M

Marshall Barton

Ofer said:
Also, just rememberd

Putting > in the format property of the text box will make it UpperCase


Note that using > will truncate long Memo fields to 255
characters.
 
Top