Converting all text input to lower case

[aommaster]

Hi everyone!



This seems incredibly simple, yet, I can't get it to work.

I'd like to have all user inputs into a form (or a table, for that matter) to be converted to lower case before saving.

In essence, all data must be converted to lower case and whatever data is displayed in the table is lowercase.

From the table, I've tried changing the format of the respective field to "<" but that doesn't seem to solve the problem. For some odd reason, the data still behaves as a string with uppercase characters (and this is displayed when the data is clicked... I can see the original string with the upper case characters) even though the string looks like the conversion had been made.

I also tried to modify the form directly, by using the OnChange event = =LCase([Process Path].[Text]), where Process Path is the name of the field in question.

However, this seems to do the same thing as setting the field format to ">".

What am I doing wrong? How can I fix this?

Thanks again

[RuralGuy]

You can do it in the KeyDown event if you want.

[aommaster]

Hi RuralGuy!

Thanks for your reply. Unfortunately, I don't have much experience with programming in Access, so could you please elaborate on that?

Also, was the method I applied (both by using field formats and form events) wrong usage? If not, why didn't it work? It seemed like the original string value had upper cases in, while it displayed as lowercase. Is there a way of changing that?

Thanks again for your time

[RuralGuy]

Using the Format instructions *only* changes how the field is displayed, not how it is stored. I rarely use the OnChange event. Is the name of the control [Process Path] as well as the field to which it is bound? I would change the control name to txtProcessPath so there is no confusion. I'll get you the KeyPress code but you will need to turn on the KeyPreview of the form for it to function correctly.

[RuralGuy]

Here's the KeyPress event for the control you want held to LowerCase:

Private Sub YourControl_KeyPress(KeyAscii As Integer)
 
   Select Case KeyAscii
      Case 65 To 90
         KeyAscii = KeyAscii + 32
   End Select
 
End Sub

...using YourControl name of course. Remember to set the KeyPreview for the FORM to YES.

[aommaster]

Hi RuralGuy!

Thank you very much for your reply. I also see what you did with that. You just shifted the character code up the ascii table to have it switch to lower case. I do have a fair bit of programming experience (some of which is VB .Net), but I've never really done anything in Access.

Thanks again for your great help RuralGuy! I really appreciate it

[RuralGuy]

Glad I could help.