Subject | How to get blank edits???? |
---|---|
Author | Michael L. Horne |
Post date | 2002-05-23T05:14:21Z |
Hello
I have some currency fields defined as
CREATE DOMAIN T_CURRENCY AS NUMERIC(9,2) DEFAULT 0
that my users wish to see blank if the value is zero.
I am using
FieldsDisplayFormat = T_Currency=0.00;-0.00;#
to achieve that. However, if the user enters a TIB_Edit field
to edit, then a '0' shows up. How can I cause those fields
to remain blank for them to key into. I don't want the
fields in the db to be null, I want them to contain '0'
if the value is zero.
What properties do I need to set to obtain this.
So to recap, how do I configure IBO to allow a field to
display/edit as '#.##' if it has a value but as blank with
a value of zero.
Thanks
Michael L. Horne
I have some currency fields defined as
CREATE DOMAIN T_CURRENCY AS NUMERIC(9,2) DEFAULT 0
that my users wish to see blank if the value is zero.
I am using
FieldsDisplayFormat = T_Currency=0.00;-0.00;#
to achieve that. However, if the user enters a TIB_Edit field
to edit, then a '0' shows up. How can I cause those fields
to remain blank for them to key into. I don't want the
fields in the db to be null, I want them to contain '0'
if the value is zero.
What properties do I need to set to obtain this.
So to recap, how do I configure IBO to allow a field to
display/edit as '#.##' if it has a value but as blank with
a value of zero.
Thanks
Michael L. Horne