R
ragtopcaddy via AccessMonster.com
I have tried using the format function ( Format([09],"0.000000;(0)") ) in the
record source for the subform, as well as the subform textbox itself. I can't
get it to work anywhere!
When the table that is queried is updated in my code, any values <0 are
entered as -0.00000001. I then limit my display to 6 decimal places so that
this negative value displays as a 0. In order to let the user know that a
value was, in fact, calculated for the field but it was less than 0 (IOW, the
code didn't fail to calculate a value and consequently the field value
remains as the default value, 0).
Hence, the attempt to format it so as to let the user know that the
calculation succeeded, but the value returned was less than 0.
As it is, whether in the query or in the continuous subform, the formatting I
am trying to apply returns "0.000000" for the negative value "-0.00000001"
that is in the table, rather than the "(0)" I am trying to display.
record source for the subform, as well as the subform textbox itself. I can't
get it to work anywhere!
When the table that is queried is updated in my code, any values <0 are
entered as -0.00000001. I then limit my display to 6 decimal places so that
this negative value displays as a 0. In order to let the user know that a
value was, in fact, calculated for the field but it was less than 0 (IOW, the
code didn't fail to calculate a value and consequently the field value
remains as the default value, 0).
Hence, the attempt to format it so as to let the user know that the
calculation succeeded, but the value returned was less than 0.
As it is, whether in the query or in the continuous subform, the formatting I
am trying to apply returns "0.000000" for the negative value "-0.00000001"
that is in the table, rather than the "(0)" I am trying to display.