G
Guest
How do I make any text entered in a table always save it as proper case? for
instance if I have a text field say Lastname, and in it I put the last name
of the person, no matter what the caps lock is, if i type smith it will
always make it Smith? If I type SMITH it will convert it to Smith?
I have tried the Format >L<??????? and it doesn't work,
I have tried to put in an input mask but if I type smith it balks and says
wrong format.
Is there a function i can use like excell =PROPER(A2)
instance if I have a text field say Lastname, and in it I put the last name
of the person, no matter what the caps lock is, if i type smith it will
always make it Smith? If I type SMITH it will convert it to Smith?
I have tried the Format >L<??????? and it doesn't work,
I have tried to put in an input mask but if I type smith it balks and says
wrong format.
Is there a function i can use like excell =PROPER(A2)