Customization - show blank if zero

Epicor ERP 10
1

TLDR: Can you make a field be blank if value is zero.

I have just added a custom text box to a form that is linked to a custom decimal column in the relevant table.
Is there a way to get the box to be blank if the linked data is zero?

Thanks
Steve

2

In the field mask try using >

Field help for the format field in extended properties gives you this.

Format:
Enter a value in the Format field to specify the data type and maximum field length.
Values for field length can be less than the default size, but they cannot be larger.
If you attempt to enter a length larger than the maximum allowed for the field, an error message displays. Available formats:

  • Character String - Use the x value, followed by how many characters you want available in the field.
    For example, x(10) indicates that ten characters are available; x(50) indicates that 50 characters are available.
  • Boolean - Use Y/N to indicate that this field holds a True or False value.
  • Date - Use 99/99/99 to indicate that this field contains a date value.
  • Numeric - Use the 9 value according to the number of digits, including decimals, you want available in this field. You can also suppress the zero by using the > symbol, and you can allow negative values by using the - symbol.

The maximum value you can enter in this field is: ->>>,>>>,>>9.99999

4 Likes
3

Thanks Simon.