Create Report using fields from Form's datasheet

's Computer Specifications

I have a form in datasheet view and I have a control that allows me to view
and hide various fields. I would like to be able to click a button to create
a report for printing using the fields that are visible on the datasheet. I
don't need to be able to save the report for later use. I'd like it to open
the report in layout view so I can edit field sizes and what not to ensure
the report fits on one page (usually). Thanks again!

's Computer Specifications

I would just push the data to Excel.

--
Duane Hookom
MS Access MVP

"Gntlhnds" <(E-Mail Removed)> wrote in message
news:0F42D404-80F7-4657-BD3C-(E-Mail Removed)...
> I have a form in datasheet view and I have a control that allows me to
> view
> and hide various fields. I would like to be able to click a button to
> create
> a report for printing using the fields that are visible on the datasheet.
> I
> don't need to be able to save the report for later use. I'd like it to
> open
> the report in layout view so I can edit field sizes and what not to ensure
> the report fits on one page (usually). Thanks again!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Updating Fields On A Datasheet Form	=?Utf-8?B?RWFybENQaGlsbGlwcw==?=	Microsoft Access VBA Modules	6	16th Feb 2007 09:16 PM
programmatically hiding fields in a datasheet form	@.	Microsoft Access Forms	2	19th Aug 2006 09:59 PM
Not able to edit fields in an editable datasheet form	Andi	Microsoft Access Forms	1	23rd Sep 2004 06:12 AM
How can I create a datasheet-like form?	Dave	Microsoft Access Forms	2	17th Mar 2004 05:23 AM
Using wizard to create 'datasheet' form	David	Microsoft Access Getting Started	2	16th Dec 2003 10:51 PM