Hi!
Can an update query be used to set the text in table to proper case. I have [address1] in tblClientdemographics and many of the addresses are in upper case. I would like them to be consistently in proper case.
Thanks!
Leesha
Update Query to Set text to Proper Case
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
-
- Administrator
- Posts: 78595
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Update Query to Set text to Proper Case
Yes:
UPDATE tblClientdemographics SET address1=StrConv(address1,3)
3 is the numeric value of the symbolic constant vbProperCase.
The same warning applies that I mentioned in your earlier thread about names. MCDONALD DRIVE will be converted to Mcdonald Drive, not McDonald Drive.
UPDATE tblClientdemographics SET address1=StrConv(address1,3)
3 is the numeric value of the symbolic constant vbProperCase.
The same warning applies that I mentioned in your earlier thread about names. MCDONALD DRIVE will be converted to Mcdonald Drive, not McDonald Drive.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Update Query to Set text to Proper Case
Thanks Hans! I appreciate the help and the tips!