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?
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?
In the ON PRINT event of the report,
TxtBox.visible =txtbox >0
I'd probably use Conditional Formatting?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
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.
@isladogs
Well noted
Or use the format property which technically will be quicker than conditional formatting
Something like
,,’’