Display or Hide Line Item Invoice Pricing in Access

In this Microsoft Access tutorial, I will show you how to toggle line item pricing on invoices with ease, perfect for creating detailed or summary invoices. We'll add just a touch of VBA to make your reports more flexible, avoiding the hassle of maintaining separate invoice templates. A practical solution for enhancing your database's invoicing capabilities.

Ivan from Paramus, New Jersey (a Platinum Member) asks: How can I make my invoices in Access show prices for each thing we sell, but also hide those prices when I need to? Like, if I want to give a customer a summary invoice without all the details of what each item costs. Can I do that in the same report or do I need to make two different ones?

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Invoicing
• Intro to VBA
• If Then

Links

• Update Queries
• On Current

Recommended Courses

• Access Expert 1

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, on format, onformat, show hide line item pricing, invoice customization, VBA programming Access, conditional visibility report, toggle price display Access, Access report controls, modify Access reports, detail section on-format event