Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Undefined Function in Access 2007

Avatar of tyrfing
tyrfing asked on
Microsoft Access
7 Comments1 Solution935 ViewsLast Modified:
I am trying to convert strings in Access to Proper Case.  I'm calling the function I created "ProperCase" in a query and I continually get the "undefined function" error.  I have clicked on the Tools References and don't find any "missing" references at all.  I can't compile the code because the "compile" line is dimmed.  The code has worked in previous versions of access, so I figured I'm just not calling it up right.  The code is entered as a module and named "Propercase".  I am simply calling it in an update query as Propercase([FirstName]), when I get the error.

Any help would be appreciated.
Option Explicit           ' Require variables to be declared before being used.
Option Compare Database   ' Use database order for string comparisons.
Function ProperCase(strToChange As String) As String
    ' Converts string to Proper case
    On Error Resume Next
    ProperCase = StrConv(strToChange, vbProperCase)
End Function
Avatar of madgino
madginoFlag of Romania image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers