1 Reply Latest reply on Apr 9, 2014 5:47 AM by philmodjunk

    How to display field content in same format?

    margagb

      Title

      How to display field content in same format?

      Post

           I want to make sure that a serial number (key field) that starts with PL always show the PL. Right now only when a new record is created the field shows the entire number including the PL (e.g. PL123), but the reports don't. They just show 123. How do I correct this. I can do this probably with a function, but don't know which one and how… Thanks for your help.

        • 1. Re: How to display field content in same format?
          philmodjunk

               Is this field on the reports the same field that you see "when a new record is created"? Is this a field of type number when it should be of type text? (You can use manage database to change the data type of a field). But be aware that if you have this field defined as a field of type number and you change it to text, it will sort differently.