I am up to Access Expert 32. I'm working on a project where I will print 3 tickets that are perforated into 3 tickets 1and 1/2 inch by 4 inch. I do have this project that works okay but I would like to take this to the next level.

Each ticket displays a registration number, Event Name, Date and Time, Room, etc. I would also need each ticket a different background color.

I also need to be able to either print or leave blank 1,2 or all three or be able to print VOID in red as an overlay on the tickets, whatever is easier. Is this a simple concept or is it something that will be covered in a later class. My convention is in November. If you can help me, I will appreciate it. Looking forward to the next lesson.

---

Reply from Alex Hedley:

There are a number or things you could do.

You could use some vba to achieve this with Conditional Formatting
Extending the Functionality of Conditional Formatting in Access

If you want blank tickets just create some blank rows into your recordset so they don't show anything.

To show VOID across the Ticket have another field/column in your Table that's a boolean. Check it when you want Void.
Now add a label on your Report that has a visibility set to this boolean value so it'll show when you check.