Alpha Video Training
Results 1 to 5 of 5

Thread: Formating object text in a report

  1. #1
    Gerry Duggan

    Default Formating object text in a report

    I was recently asked to consolidate several tables
    prepared by others in one database. I imported the tables
    with no problem however one particular table had all the
    data in one of the text fields (i.e. Field - Name of City)
    in upper case. I would like to design a report including
    this field but I would like to convert the text case in
    the Name of City field to upper case for the first letter
    in each word and lower for the rest. I tried putting in a
    mask in the format section of the object properties with
    no success.

    Would appreciate any suggestions.



  2. #2

    Default RE: Formating object text in a report

    Try creating an operation to do this. Run an Update Records operation and that should do it. Of course, before mucking with your data, have a good solid backup.

  3. #3
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    S.E. Michigan

    Default RE: Formating object text in a report

    The update expression should look something like this:

    Field to Update - City

    Expression - w_upper( lower ( City ) )

    This expression first changes the City text to lower case then converts the lower case to "first letter of each word upper case".

    And, by the way, I put a script on the Learn Alpha site with updates in the Code Archive some time ago which I call Check_Caps. (It's under the title "Improved Capitalization Checker" - just search for capitalization in the code archive.) It is used for entering mixed case text without requiring the user to press the Shift key. If the user types all lower case, the routine will change most words to "first upper" and also check for words that might normally have two letters upper case such as McDougall. If the user types mcdougall, the routine asks whether to use Mcdougall or McDougall. (If it didn't ask, you would end up with MacHine instead of Machine.)

    Note that I said "most" words - words like and, or, the, a, in, etc. are only capitalized at the beginning of the field.

    Also, any letters entered in upper case will be left as upper case. Therefore, the user could type "the aBC tool and die company" to get "The ABC Tool and Die Company". (Although, at least in my own version, I added "ABC" as a 'word' that should always be capitalized. Therefore, the user wouldn't even have to capitalize the BC.)

    I recently updated my own version to add the ability to create other unusual capitalizations when necessary. This would be for things like DelWood which the routine would normally look at as a "De" word and prompt for "DeLwood or Delwood" - neither of which is correct. This can be accomplished in the published version by typing delWood so it will prompt for DeLWood or DelWood - the problem is that this will usually mean re-entering the whole field because the user probably won't think of this until after it's typed.

    Cal Locklin

  4. #4
    Gerry Duggan

    Default RE: Formating object text in a report

    Thanks Ed - Operation worked.


  5. #5
    Gerry Duggan

    Default RE: Formating object text in a report

    Thaks Cal - Really appreciated.


Similar Threads

  1. RTF Object Calc Formating
    By Alan Lucas in forum Alpha Five Version 5
    Replies: 3
    Last Post: 02-28-2005, 03:01 AM
    By Rawlings in forum Alpha Five Version 5
    Replies: 0
    Last Post: 09-22-2004, 06:15 AM
  3. Report Formating Question
    By Jesse Sanders in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-12-2004, 04:53 AM
  4. Formating Imported Text
    By Gary Ryder in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-02-2003, 12:58 AM
  5. Report text object
    By Ed Barley in forum Alpha Five Version 5
    Replies: 22
    Last Post: 10-14-2003, 10:33 AM


Posting Permissions

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