Normalizing formatting in Access 2010

[Briilee]

Hi, I've recently gotten tasked with cleaning up in an old database containing employee information. For some reason, the person who made it decided that all entries should be written IN ALL CAPS.


Therefore I'm looking for an quick way to normalize the data. And apply this to a range of cells. Much like you can use =PROPER(A1) in Excel.
Thanks in advance!

[ItsMe]

Sounds like you are interested in the StrConv() function with the vbProperCase argument

Dim str As String

str = StrConv("ALL CAPS", vbProperCase)
MsgBox str

[CJ_London]

this query will update all myfields in myTable to propercase

UPDATE myTable SET myField= StrConv([myField],3)

[IrogSinta]

There are valid reasons for making all entries for certain fields in caps. For instance, if you are using a linked Oracle table, the fields here are case sensitive. So searching for SMITH will not return the results for Smith or smith. In addition, you may have various people entering data in their own preference so while some may type in John Smith, others may just put in john smith, JOHN SMITH, John SMITH. Forcing them into caps in the table makes it easier to find a string. Then for display purposes on forms or reports, you can just use the StrConv function. Now if you are just using Access tables, which are not case sensitive, then this is not an issue.

[CJ_London]

if you are using a linked Oracle table, the fields here are case sensitive

good catch!