Results 1 to 4 of 4

Thread: All caps

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Angry Unanswered: All caps

    In Access 2002 and previous versions, when I format a memo field with ">" to display all caps, the field truncates and will no longer act as a memo field. It will only display 250 characters. The field will still hold the data but simply will not display it.
    Any suggestions?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: All caps

    Originally posted by Gunns603
    In Access 2002 and previous versions, when I format a memo field with ">" to display all caps, the field truncates and will no longer act as a memo field. It will only display 250 characters. The field will still hold the data but simply will not display it.
    Any suggestions?
    Try using UCase function instead ... Internally I believe that the MS textbox control can hold 65535 characters (which also is the MAX limit of the Memo field) ... Just a coincidence?

  3. #3
    Join Date
    Mar 2004
    Posts
    2
    That is what I tried. When I add ">" to the function in properties of the memo field, I get all caps but I also get the display truncated.

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by Gunns603
    That is what I tried. When I add ">" to the function in properties of the memo field, I get all caps but I also get the display truncated.
    Remove it from the table format ... Perform the UCase on your save/update ...

Posting Permissions

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