By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,702 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,702 IT Pros & Developers. It's quick & easy.

Print out the data sheet portion of a split form

P: 30
I have a form that is split so that the data sheet view is at the bottom. I don't want to change the print property on the forms properties tab, I'd like to leave it on "Form only" because the form is printed 99% of the time. I'd like to add a button to print out the data sheet, so it's available as an option if needed. Any idea's on how I'd set the focus to the data sheet to print?
Apr 17 '15 #1
Share this Question
Share on Google+
4 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
It would probably be easiest to create a report that looks the way that you want it to with all the appropriate filters and then print that.
Apr 17 '15 #2

P: 30
The filters will change though depending on what information the user wants. So I can't make a report with predefined filters.
Apr 17 '15 #3

Seth Schrock
Expert 2.5K+
P: 2,951
You don't have to have predefined filters. You can pass the filters to the report when you open it to print it.
Apr 17 '15 #4

Expert Mod 5K+
P: 5,397
Seth is correct.
Filters can be created and passed on the fly.

Forms are not normally printed; however, if you insist then one can add a command button to the header in design view and use a VBA script to toggle the form print state from printing the grid to printing the form. The caption of the command button can be changed to indicate status... for that fact, the colour can be changed too. The button can be set to be visible only on screen and not when printed.

Apr 17 '15 #5

Post your reply

Sign in to post your reply or Sign up for a free account.