Force entry to lower case

[gripper111]

I have a db and I have a particular field on a form that I copy and paste into. Sometimes what I paste is all uppercase and other times not. I would like to force all entries in the cell to automatically convert to lower case.

I have tried a couple things but it is not working. I know this is simple but I am over looking something.

I appreciate any assistance

 

[lameid]

If the text box you are updating is named txtField1, on the afterupdate event of that control you could use the following code.

Me!txtField1 = lcase(Me!txtField1)

 

[TheAceMan1]

How are ya gripper111 . . .

Try [blue]lameid[/blue] code in the [blue]On Exit[/blue] event of the control ...

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[gripper111]

That did the trick. Thanks guys