Call a Module in an Update Query

[Bagger]

I have a table where the Authors Names all in upper case. I would like to via an update query call a module to make first character of name upper case. I lack the knowledge to know how to do a "call"

thanks in advance

 

[tlbroadbent]

In Access 2000...

UPDATE MyTable SET MyTable.[Name] = StrConv([Name],3);
Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com