ToTitleCase

[SusanV]

I've used this in VB.Net, is this functionality available in Access 2000?
Can't find anything on it for Access so I'm guessing it is not?

TIA,

Susan

 

[Ken Snell [MVP]]

VBA has a StrConv function that may do what you seek. It has various
settings that dictate the output format.

You can use this function directly within a query. Check it out in ACCESS
Help and post back if you have questions.

 

[SusanV]

Thanks Ken,

I found this link, which I thought others might also find useful:

http://msdn.microsoft.com/library/d...en-us/modcore/html/deconconvertingstrings.asp

(link may wrap)

Susan