Show a text on report only when a checkbox is checked

[Xiphiaz]

Hi,

I'm using a report to print a label to put with defective parts we receive.
Some of these parts need to be Scraped, if this is the case then I want in big letters "scrap" on the report.

I want to use for this the same report that I'm also using for the non-scrap parts.
The control of "scrap" is a checkbox on my Form.

So: if "scrap checkbox" is checked in my form only than show big "SCRAP" on report.

Can anyone help me on this? Thanks

 

[Remou]

Use the Format event of the report to set the visibility of say, txtScap:

[tt]Me.txtScrap.Visible=Me.Scrap[/tt]

 

[Xiphiaz]

It works! to good...
But thanks alot I'm a big step closer to were I want to be.

The problem that I now have is:
The report is as big as an A5 piece of paper, so it will print 2 on one page.
Somehowe it now shows a page with or without 2x "scrap" even if one isn't scrap...
If both are not scrap then it will never show scrap.

Hope you understand what I mean...

 

[Crowley16]

you will need to use conditional formatting in this case, try making the colour of the background and foreground the same for the control if the checkbox is ticked...

--------------------
Procrastinate Now!

 

[Remou]

Crowley16
Your statement is not true of reports. The method I posted is a standard solution to this problem, recommended by DHookom amonst others, furthermore I tested the line before I posted and it works for me. It seems likely that there is some other problem.

 

[Xiphiaz]

... Remou, your solution works perfect!
I had put it on the Report/On Page event...[flush]
Now I placed it on the Detail bar/On Format Event and it works perfectly...

Thanks!
(Damn I feel Noob )