Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

CaseConvert

Discussion in 'Information Technology' started by AB, Jul 28, 2006.

Tags:
  1. AB

    AB
    Expand Collapse
    Guest

    Iopened a MS Access 2003 database that used CaseConvert- I got errors
    I commented out the code and it works - is there a CaseConvert function for
    ProperCase in Access 2007?

    Private Sub Address1_AfterUpdate()

    ' If Address1 <> "" Then
    ' Address1 = CaseConvert(Address1, 3)
    ' End If
    End Sub
     
  2. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Try the StrConv() function.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "AB" <AB@discussions.microsoft.com> wrote in message
    news:6B1FA2D2-E80E-49C3-9DE1-DDF0501D5326@microsoft.com...
    > Iopened a MS Access 2003 database that used CaseConvert- I got errors
    > I commented out the code and it works - is there a CaseConvert function
    > for
    > ProperCase in Access 2007?
    >
    > Private Sub Address1_AfterUpdate()
    >
    > ' If Address1 <> "" Then
    > ' Address1 = CaseConvert(Address1, 3)
    > ' End If
    > End Sub
     

Share This Page