How to Capitalize words

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

Have a table (Persons) with 2 fields (LastName) and
(FirstName). There are several thousand records. How can I
capitalize both the last names and first names and leave
the records intact.
 
1. Create a query into this table.

2. Change it to an Update query: Update on Query menu.
Access adds an Update row to the grid.

3. Under the LastName field, enter:
UCase([LastName])

4. Under the FirstName field, enter:
UCase([FirstName])

5. Run the query.
 
Thanks, Allen, your suggestion resulter in all being
capitalized, but taking your lead, found that in an update
query, I used STRCONV([LastName],3)and got the first
letter only to capitalize, as I needed.
-----Original Message-----
1. Create a query into this table.

2. Change it to an Update query: Update on Query menu.
Access adds an Update row to the grid.

3. Under the LastName field, enter:
UCase([LastName])

4. Under the FirstName field, enter:
UCase([FirstName])

5. Run the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Have a table (Persons) with 2 fields (LastName) and
(FirstName). There are several thousand records. How can I
capitalize both the last names and first names and leave
the records intact.
Click to expand...


.
Click to expand...
 
Back
Top