General information
Category:
Coding, syntax & commands
>I have several editboxes on assorted pageframes on a form. Some of the UPPER (change text to all caps within the editboxes) commands work and some don't.
>
>Here is one editbox example:
>
>In the LostFocus Event of the editbox I have -
>REPLACE mytable.myfield WITH UPPER(mytable.myfield)
>
>For properties I have -
>ControlSource = mytable.myfield
>Format = !K
>Read Only = .T.
>Enabled = .T.
>
>But I change Read Only to .F. when in Add record or Edit record mode so the editbox can be typed into.
>
>Any ideas why UPPER works for some of my editboxes and not others. It looks like I have the same general propety settings for all editboxes.
>
>Thanks for your ideas.
Hello Steve!
I guess, this problem nothing to do with UPPER but REPLACE.
No replacement occurs, if it is eof in the current workplace, even you preface the field with its alias. So try one of the followings:
a.
select myalias
replace field with upper(field)
b.
replace myalias.field with upper(myalias.field) in myalias
BB
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only