Making all letters CAPS

[childlead]

Hi.

I want to code a textbox such that when a user enters a text, it is automatically stored in CAPS format. For example, when the user enters "apple", I want to code in such a way that it will be stored as "APPLE" in the tables. Thank you very much for your help.

 

[LittleSmudge]

Two options.

1)
In the text box Format property put ">"
This will allow users to type in lower & upper case but when the control loses the focus it all changes to UPPER case.
However, the data stored in the Bound field in the table is in the case As TyPeD.

2)
In the table design in the field you want to store the data in put the ">" in the Format property there.
The text is converted to UPPER case as the user types and is stored in UPPER case all the time.



'ope-that-'elps


G LS

 

[Quintios]

Hadn't heard of those options before.

This is what I did with my db:

Private Sub fieldname_AfterUpdate()

    Me.fieldname.Value = StrConv(Me.fieldname.Value, vbUpperCase)

End Sub

So when the user hits enter or tab or whatever, the value is converted to uppercase.

Have fun!
Onwards,

Q-