Can I make is so all values entered into a text field are formatted to be upper case letters?


I want all text values in a field to be captial letters, I just don't know whether this is something you can specify in Access.

Thanks for your help

Yes, you can do this. Look up UCase in Help, and also look up input masks. Which you use depends on whether you are converting existing data or ensuring new data is correctly entered.

If you only want them displayed as capitals, set the format for the textbox to >

Thanks for your help guys, either of your replies will do me just fine

In VBA code window

Private Sub Text1_AfterUpdate()
Text1=UCase(Text1)
End Sub

sueviolet, you need to understand that there is a difference between how something is formatted and how it is displayed. Use the UCase() function to force the field to be stored as upper case. The format applied to a table does not in all cases follow through queries to reports, etc.

OK thanks guys, I understand