If you want all caps - in the table design, form design or where ever you want the text in capitals is to use the greater then symbol ">" in the format property of the text box,"<" is for lower case
If you want only some of the letters in caps then Input mask is what you would want to use.