proper case in access

Discussion in 'Microsoft Access' started by Guest, Nov 2, 2005.

  1. Guest

    Guest Guest

    Is there a function that will convert my text from ALL CAPS to Proper Case?
    I've found some postings with vbProperCase but I don't know vb.
     
    Guest, Nov 2, 2005
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    You can use StrConv - you might want to start by making a backup of your
    database! Then create a SELECT query that includes the field that you wish to
    update. Convert this query to an UPDATE query – use the Expression Builder in
    the Update row of the grid as follows:

    Field: MyFieldName
    Table: MyTableName
    Update To: StrConv([MyFieldName], 3)

    Note for Uppercase use 1 and lower case use 2 – this actually changes the
    case rather than the format property which only changes how text is displayed.


    "mktg@wfi" wrote:

    > Is there a function that will convert my text from ALL CAPS to Proper Case?
    > I've found some postings with vbProperCase but I don't know vb.
     
    Guest, Nov 2, 2005
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Thank you, that worked great. But now I have a follow up. Is there any way
    to avoid issues like acronyms going from ABC to Abc? Or ABC LLC going to Abc
    Llc?

    "Sheila D" wrote:

    > You can use StrConv - you might want to start by making a backup of your
    > database! Then create a SELECT query that includes the field that you wish to
    > update. Convert this query to an UPDATE query – use the Expression Builder in
    > the Update row of the grid as follows:
    >
    > Field: MyFieldName
    > Table: MyTableName
    > Update To: StrConv([MyFieldName], 3)
    >
    > Note for Uppercase use 1 and lower case use 2 – this actually changes the
    > case rather than the format property which only changes how text is displayed.
    >
    >
    > "mktg@wfi" wrote:
    >
    > > Is there a function that will convert my text from ALL CAPS to Proper Case?
    > > I've found some postings with vbProperCase but I don't know vb.
     
    Guest, Nov 2, 2005
    #3
  4. Guest

    Guest Guest

    Hmmm - can't think of any unless you know what they are and can use criteria
    to exclude those from the update? There may be a way using VB but I'm not a
    VB person I'm afraid, Sorry

    Sheila

    "mktg@wfi" wrote:

    > Thank you, that worked great. But now I have a follow up. Is there any way
    > to avoid issues like acronyms going from ABC to Abc? Or ABC LLC going to Abc
    > Llc?
    >
    > "Sheila D" wrote:
    >
    > > You can use StrConv - you might want to start by making a backup of your
    > > database! Then create a SELECT query that includes the field that you wish to
    > > update. Convert this query to an UPDATE query – use the Expression Builder in
    > > the Update row of the grid as follows:
    > >
    > > Field: MyFieldName
    > > Table: MyTableName
    > > Update To: StrConv([MyFieldName], 3)
    > >
    > > Note for Uppercase use 1 and lower case use 2 – this actually changes the
    > > case rather than the format property which only changes how text is displayed.
    > >
    > >
    > > "mktg@wfi" wrote:
    > >
    > > > Is there a function that will convert my text from ALL CAPS to Proper Case?
    > > > I've found some postings with vbProperCase but I don't know vb.
     
    Guest, Nov 3, 2005
    #4
  5. Guest

    Guest Guest

    Thanks for the help. This saved me a lot of time.

    Matt

    "Sheila D" wrote:

    > You can use StrConv - you might want to start by making a backup of your
    > database! Then create a SELECT query that includes the field that you wish to
    > update. Convert this query to an UPDATE query – use the Expression Builder in
    > the Update row of the grid as follows:
    >
    > Field: MyFieldName
    > Table: MyTableName
    > Update To: StrConv([MyFieldName], 3)
    >
    > Note for Uppercase use 1 and lower case use 2 – this actually changes the
    > case rather than the format property which only changes how text is displayed.
    >
    >
    > "mktg@wfi" wrote:
    >
    > > Is there a function that will convert my text from ALL CAPS to Proper Case?
    > > I've found some postings with vbProperCase but I don't know vb.
     
    Guest, Dec 28, 2005
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John

    Change Case for Proper Name

    John, Jul 15, 2003, in forum: Microsoft Access
    Replies:
    1
    Views:
    187
    chriske911
    Jul 15, 2003
  2. Susan

    converting uppercase to proper case

    Susan, Mar 31, 2004, in forum: Microsoft Access
    Replies:
    4
    Views:
    259
    Lynn Trapp
    Mar 31, 2004
  3. j

    Smart Proper Case VBA

    j, Nov 8, 2004, in forum: Microsoft Access
    Replies:
    0
    Views:
    245
  4. Guest

    how to change upper case to proper case

    Guest, Feb 11, 2005, in forum: Microsoft Access
    Replies:
    3
    Views:
    303
    Joseph Meehan
    Feb 11, 2005
  5. Guest
    Replies:
    1
    Views:
    528
    Douglas J Steele
    Jun 16, 2005
Loading...

Share This Page