capitalization

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

I have a form in my database used for input several pieces of information.
The text boxes are unbound. I need to specify that one of the text boxes is
lower case and the other upper case. I am only familiar how do this in the
design view of a table.

Is there a way to specify capitalization rules in the properties of a text
box?

Thank you in advance for any assistance.

LB
 
You can specify this in the Format of the textbox, just as you can in the
table. However, changing the format only changes the way it looks, not what
is actually there. There may be an "A" stored, but you would see it as "a".
If you want to change what is stored, then in the AfterUpdate event of the
textbox, convert the text to the desired case.

Example:
Me.txtMytextbox = LCase(Me.txtMyTextbox)
 
Back
Top