Is this possible?

[sueviolet]

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

 

[AncientOne]

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.

 

[Fizzio]

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

 

[sueviolet]

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

 

[IgorB]

In VBA code window

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

 

[sueviolet]

OK thanks guys, I understand