Reports Only Coming up in Form View - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Reports Only Coming up in Form View

Tim Elbert

8 months ago

Several of my reports, not all, are coming up in form view rather than print preview. Ihave them set to open up in print preview. Also, there is no option to open them in print preview. This is a new thing so I must have done something. They used to come up in print preview all the time. In order to change them to design view I have to right click and then click on the 'design view' tab. All the options in the menu are greyed out.

	Tim Elbert OP @Reply 8 months ago

	Tim Elbert OP @Reply 8 months ago

	Tim Elbert OP @Reply 8 months ago

	John Davy @Reply 8 months ago
Hi Tim, Show me the code you use to open the report. John

	John Davy @Reply 8 months ago
Hi Tim, if you use a button try this, just use your report name: DoCmd.OpenReport "OrderAndPaymentR", acViewPreview John

	Tim Elbert OP @Reply 8 months ago
They open this way from left hand menu as well as the buttons. Here is the macro...

	Tim Elbert OP @Reply 8 months ago

	Raymond Spornhauer @Reply 8 months ago
Tim The first picture you posted is Print Preview. I'm not sure what you're meaning when you say some 'Reports' are opening in 'Form' view. Do you mean the Form opens instead of the report? Or the Report Opens in Report View and not Print Preview? -Raymond

	Richard Rost @Reply 8 months ago
Tim the picture that you uploaded shows a report in print preview. Are you saying that it's opening in report view?

	Tim Elbert OP @Reply 8 months ago
Ok, I figured it out. I set pop-up and modal to yes so it would not allow the print function to work. I turned these off and now it works.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View