Showing value as a zero or a null in a bound field

[Former Community Member]

I have a table in a livecycle form that is bound to fields in a SQL database.  There are both zero and null values in the database that I want to show as such in the table, but any zero values appear as blank when previewed in PDF or published.  The cell pattern is currently set to null{}|zero{}|num{z,zzz,zzz,zz9}, but changing the pattern to null{}|zero{0}|num{z,zzz,zzz,zz9} or null{}|zero{'0'}|num{z,zzz,zzz,zz9} results in this err msg:

Thanks for any help!

[radzmar]

Hi,

Filling the zero pattern with a string, like zero{'0'} should work.

I looks like the is something that tries to set/replace the pattern at runtime.

Do you use any scripts?