Change Case in Query 1

[gsd]

I am trying to run a query and change the data in a table from UPPER case to just the first letter in each word capitalized. I see there is a Proper () function and I know how to use it in excel but can I use it in a query in MS Access? Please Help!

 

[DougP]

=Proper([Myfield])<br>
Put your field name in there where my field is. Inside brackets with the equal sign.<br>
<br>
Hey Proper() is not in Access '97 ?????????<br>
Said &quot;keyword not found&quot; in Help<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[JimHorton]

If I'm not mistaken, Proper() was an add-in function from one of the mwind.mdb's, there were a whole mess of these utility functions in there. I guess it became so common that it was thought as a defacto 'standard' function.<br>
--Jim

 

[gsd]

Doug, It did not work. In access 2000 help they call it proper worksheet function. I am not sure if this is just for excel worksheets or not. Thank you.

 

[DougP]

OK I found it<br>
It's in &quot;Orders.mdb&quot; sample db that comes with Access in &quot;UtilitiesFunctions&quot; Module <br>
here it is<br>
Click your &quot;Modules&quot; tab <br>
Create a New Module<br>
In the white space paste this code then close the module and save changes<br>
-----------------------------------------------------<br>
Public Function Proper(strToChange As String) As String<br>
' Converts string to Proper case<br>
On Error Resume Next<br>
Proper = StrConv(strToChange, vbProperCase)<br>
End Function<br>
-------------------------------------------------------<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[gsd]

Thank you so very much for your help it works!!!!!!!!!!!!!!!!!!!!!!!