2 Replies Latest reply on Aug 1, 2012 8:27 AM by RobertMoya

    Auto-Fill with Letters

    RobertMoya

      Title

      Auto-Fill with Letters

      Post

      I have FMPRO12 and i know how to make a sequence with numbers across multiple fields. I was wondering if theres a way to do the same thing, but with letters.

      Thanks

        • 1. Re: Auto-Fill with Letters
          philmodjunk

          It's possible with the right calculation. Did you really mean "across multiple fields"? Or did you really mean "across multiple records"?

          Here's a hint to point you in a possible direction:

          Option 1:

          Char ( Code ( previousletter ) + 1 )

          Option 2:

          Char ( Code ( "A" ) - 1 + SerialNumberField )

          Note that this limits you to a single letter sequence of characters. A more sophisticated approach would be needed to work with multiple characters.

          • 2. Re: Auto-Fill with Letters
            RobertMoya

            Yes, i meant across multiple records. I will give that a try and get back to you.

            Thanks