Hi

I have made a report in access 2000 based on query. Query contains some numeric fields having default value 0. This report has shown in print preview format after filling form and by clicking required button. This form has got those fields and for calculation I put defult value of those is 0. If somebody enters no data on that particular field and clicks preview button he shows that particular field having 0 value.It is redundant. It should be eliminated from the report part and also from the printing part.

How can this be possible ?
Pl let me know asap.

regards
Subho

An easy trick is to use conditional formatting and set the forecolor to the background color so that the 0 is printed or shown in white.
Otherwise you have to use vba and set the ControlSource to an empty string for the relevant textboxes. I usually use the formatting method, its easier:)

Thanks a lot edcaru for earliest reply.

But this can't solve the problem. Because value of field is not predefined and report shows this very particular value. If somebody omit then report will show 0 value as it is the default value for this.


regards

Subho

I usually use VBA in the Report code to test for the invalid 0 and thenset the control .visible prporty to False.


Cheers Ray

Is the field keeping the 0 or do you mean that there is no value?
If there is an actual 0 inserted as the value, you can use conditional formatting.

Something does not add up.



Sal

This field really contains 0 (in numeric) value by default and this settings is required for calculation. How can I stop to view this 0 in report part ? How this problem can be solved by conditional formatting ?

Pl secify with example.

thanks
Subho

Thanks to everybody and P2P.Wrox.Com Forum.

At last I have solved the problem accroding to ur advice.

thanks to all of u

Subho