7 Replies Latest reply on Feb 12, 2010 5:51 PM by techlarry

    "Grouping" Characters showing up in Field Value Lists

    techlarry

      Title

      "Grouping" Characters showing up in Field Value Lists

      Post

      Ok, something odd has started happening here that I have not seen before.

       

      When I create a Value List for, say, the field "Last Name", and put the field on a form and assign it as a drop-down to the list created for it, this is what I'm getting when clicking on the diamond in find mode.  I have the list being auto-generated from the field contents:

       

         A

       

      Anderson

      Avery

      Applebee

       

         B

       

      Bonaducce

      Blitter

      Banks

       

         C

       

      Charleson

      Crispy

      Crammond

       

         E

         F

         G

       

      Grafton

      Gregory

      Groupy

       

         H

       

      Hendricks

      Henderson

      Henry

       

      And so forth.

       

      The group letters are indented as shown above.

       

      I have looked every darned place for a way to turn this off!

       

      I've compared my List, field and form settings with another database that doesn't do this.

       

      I'm really stumped.  I've never seen this come up from nowhere before!

       

      How can I turn this off?