convert cases

[Guest_imported]

Hi,

i have a database with a surname field. now all records in this field is in upcase. how can i wrote some code or some input mask (in form or table)to change the excisting data from upcase to title case and make sure the input in the future keep in title case.

cheers

 

[yamafopa]

You probably want to run an update query to change the values to the proper case. Look up StrConv function in the help menu. Once the values have been set then you will want some code on the update event of the text control that accepts data for the field in question that enforces your case requirements.
HTH
Chris