automatically increment to uppercase, how?

[buddythebest]

in an initials field... i want it so that it could automatically increment the 3 letters to uppercase... how? if it can't be done in a table where can it be made (i.e. in a form, query etc)

 

[Smart]

Design your table and in click on the required field name then on the general tab,format type the following character >

 

[buddythebest]

thanks a lot it works... (btw: i appreciate ur concern for a newb like me )