How to add a Suffix

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MyWaterloo
    New Member
    • Dec 2007
    • 135

    How to add a Suffix

    Hi,

    I was wondering if there is anyway to add a suffix to a field automatically. I have a field that is for water flow in gallons per minute and I would like to be able to type a number and have it automatically add "gpm". Is there a way to do this? A custom format or mask? Any ideas would be greatly appreciated.

    Thank You,
    MyWaterloo
  • TheSmileyCoder
    Recognized Expert Moderator Top Contributor
    • Dec 2009
    • 2322

    #2
    Try adding this to the format property of the field:
    Code:
    #"  gpm"

    Comment

    • MyWaterloo
      New Member
      • Dec 2007
      • 135

      #3
      Thanks for the reply!

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32668

        #4
        I would suggest storing it numerically and only formatting it with the unit when it's displayed.

        A format display string might be :
        Code:
        "#,##0 gpm"

        Comment

        Working...