| | |
|
|
|
changing letter case in selected columns |
|---|
| message from =?Utf-8?B?RGVubmlz?= on 26 May 2004 |
I have a database with a mixture of records entered in all upper case and some in title case. I'd like to convert all records to title case, but it's not possible in Access 2000. Is it possible with Access 2003?
|
| Graham R Seach replied to =?Utf-8?B?RGVubmlz?= on 27 May 2004 |
Dennis,
It IS possible with Access 2000!
Dim sSQL As String
sSQL = "UPDATE tblMyTable SET MyField = StrConv(MyField, 3)"
CurrentDb.Execute sSQL, dbFailOnError
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
"Dennis" <anonymous@discussions.microsoft.com> wrote in message
news:2661FEE4-7440-4DE6-B6A9-6FF2542731E0@microsoft.com...
some in title case. I'd like to convert all records to title case, but it's
not possible in Access 2000. Is it possible with Access 2003?
|
|
Archived message: changing letter case in selected columns (Microsoft Access Error Message)
