<div>
update table<br />
set [field]=strconv([field],3)<wbr /> &nbsp;<br />
<br />
<br />
the option 3 is vbPropercase
</div>


<div>
Why not leave the data as-is?<br />
<br />
Certain Names, in certain situations are case sensitive, so changing them in the raw data may cause issues.<br />
<br />
You can change the case for display purposes in your forms and reports.<br />
<br />
<br />
If you feel confident that you must change the case globally, please make a back up of the data in it's original state.<br />
<br />
JeffCoachman
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
What is the best way to change the case of the data in the records of a db?<br />
<br />
For example, much of the data I need to convert is now in uppercase, but I would like to change it to first letter capital of each word only (sentence case?)<br />
<br />
Thanks
</div>
</div>


Hi

What is the best way to change the case of the data in the records of a db?

For example, much of the data I need to convert is now in uppercase, but I would like to change it to first letter capital of each word only (sentence case?)

Thanks

update table
set [field]=strconv([field],3)  


the option 3 is vbPropercase

Why not leave the data as-is?

Certain Names, in certain situations are case sensitive, so changing them in the raw data may cause issues.

You can change the case for display purposes in your forms and reports.


If you feel confident that you must change the case globally, please make a back up of the data in it&#39;s original state.

JeffCoachman

MS Access change case

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.