Format text colour to white when the field contains a zero (0) figure.

[Emmanuel]

I will like to format my access database report in such a way that, when the amount in the textbox is zero, it should change the color of the text to white so it won’t be visible on the report.

How do I go about that?

[ranman256]

In the ON PRINT event of the report,

TxtBox.visible =txtbox >0

[Welshgasman]

I'd probably use Conditional Formatting?

[Emmanuel]

I'd probably use Conditional Formatting?

Can you demonstrate the conditional formatting?

[Emmanuel]

In the ON PRINT event of the report,

TxtBox.visible =txtbox >0

This method couldn’t produce the results I wanted

[Emmanuel]

I'd probably use Conditional Formatting?

I tried the conditional formatting
And it worked great
Thanks for this idea

[isladogs]

This method couldn’t produce the results I wanted

For that method you would set the textbox visible property to false by default. Then it would only be visible if the textbox value >0.
The advantage of that method is it would still be hidden as you wanted even if the paper used wasn't white. Using CF, you would see the white 0 on coloured paper.

[Emmanuel]

@isladogs
Well noted

[CJ_London]

Or use the format property which technically will be quicker than conditional formatting

Something like

,,’’