I need to know how to make a field in an Access table upper case. I'm not talking about an Access form etc. These are tables maintained by the IT staff who go right into the Access table and make entries. I know the > in the Format of the Field properties will display it in upper case but it will be stored as it was entered. I don't care how it is entered. I need it to be converted and stored in Upper case. I would think it has something to do with the Input Mask on the field properties and UCASE or somehow have a macro run on it. But I can't find it anywhere on the web. All discussions talk about shifting to Upper case on a form which I know how to do.