Results 1 to 2 of 2

Thread: Data Conversion

  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unanswered: Data Conversion

    Convert text to Small Caps

    I need to convert data in a table that is ALL in UPPER CASE to Small Caps.

    Can anyone help with the sql to acheive this ?

    Thanks in advance !

  2. #2
    Join Date
    Apr 2002
    Location
    Portugal
    Posts
    146
    You can use the Format function, on an AfterUpdate event.

    like this:

    [control name]=Format(Me![control name], "<")

    Now, if you want to convert all data in a table, then create an upadate query to update usimg that function or simple run in code a cicle using a button in the form where the table is related:

    dim n as single ' n. of records in the table

    n=Dcount("[field name]","[table name]")

    docmd.gotorecord , , acFirst

    For i=1 to n
    [control name]=Format(Me![control name], "<")
    docmd.gotorecord , , acNext
    Next i

    Ciao!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •