another convert question

[minder]

now sorted thanks for looking




hi i have fout text fields on a form and what i am trying to do is this

when i update a text box and then move to another text box i want the text i have enterd in to the first box to change to upper case from lower case

any ideas?

thanks in advance for your help

rob

 

[llkhoutx]

On the BeforeUpdate or AfterUpdate event use the UCase function on on the cell's contents.

 

[minder]

thanks for the reply

got it sorted now
i put the following code in the after update event of the text field

Me.[myfield] = StrConv(Me.[myfield], 3)

thanks to all who have helped me this forum is the best on the net

thanks
rob