Solved

select specific fields to print in access report

Posted on 2008-10-24
3
270 Views
Last Modified: 2012-05-05
I want to put a tick box beside a field in an access report to select whether this field is printed or not.  Is this possible or not!
0
Comment
Question by:smalltalk10
3 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
afaik, not possible.
you can not even change the value of a tick box once the report is open.

just filter the record source of the report to display what you want to be printed
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
smalltalk10,

You can *Only* do this in Access 2007
Here is a sample
(You can only open this file with Access 2007)

JeffCoachman
Access-EEQ23844209-ShowHideRepor.mdb
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now