Results 1 to 3 of 3

Thread: Change Case

  1. #1
    Dan Hendricks Guest

    Change Case


    Can I change the case of a field with the magic cell? I have a state field that I would like to appear in uppercase.

    Thanks

  2. #2
    Mark Guest

    Change Case (reply)

    Hi Dan,
    Yes, easy. Just use:

    x.dbmagiccell = "1,,format=[>];" ' UPPER CASE the entire first name

    http://www.mmstools.com/test/test-formats.asp

    I hope that helps.
    Mark.


    ------------
    Dan Hendricks at 3/26/01 1:35:02 PM


    Can I change the case of a field with the magic cell? I have a state field that I would like to appear in uppercase.

    Thanks

  3. #3
    Frank Kwong Guest

    Change Case (reply)

    You can use any of the following characters to create a format expression for strings:

    Character Description

    @ Character placeholder
    Display a character or a space. If the string has a character in the position where the @ appears in the format string, display it; otherwise, display a space in that position. Placeholders are filled from right to left unless there is an ! character in the format string. See below.
    & Character placeholder
    Display a character or nothing. If the string has a character in the position where the & appears, display it; otherwise, display nothing. Placeholders are filled from right to left unless there is an ! character in the format string. See below.
    < Force lowercase
    Display all characters in lowercase format.
    > Force uppercase
    Display all characters in uppercase format.
    ! Force left to right fill of placeholders

    The default is to fill from right to left.

    FK



    ------------
    Dan Hendricks at 3/26/01 1:35:02 PM


    Can I change the case of a field with the magic cell? I have a state field that I would like to appear in uppercase.

    Thanks

Posting Permissions

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