473,503 Members | 2,157 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Prevent Report Preview from Escaping into Design Mode

I must be missing something, but I have a report that when it is opened
programmatically as a Preview, there is a limited toolbar which
prevents the ability to edit the design, among other things. However,
if the use presses the <ESCAPEkey, it automatically reverts to Design
Mode.

How do I prevent this?

Aug 9 '06 #1
4 1701
To be more specific, when I click on the "Preview" button on the
database window, pressing the <ESCAPEkey simply closes the form. But
when I use DoCmd.OpenReport with acPreview, the <ESCAPEkey dumps the
report into design mode.

ve******@gmail.com wrote:
I must be missing something, but I have a report that when it is opened
programmatically as a Preview, there is a limited toolbar which
prevents the ability to edit the design, among other things. However,
if the use presses the <ESCAPEkey, it automatically reverts to Design
Mode.

How do I prevent this?
Aug 10 '06 #2
This is the kind of thing that annoys me about someone following up
themselves, a post at 6pm and a followup at 8pm that includes
information that should have been included in the original post.

THINK BEFORE YOU POST THE FIRST TIME.

At 5:44pm, ve******@gmail.com wrote in
news:11**********************@m73g2000cwd.googlegr oups.com:
I must be missing something, but I have a report that when it is
opened programmatically as a Preview, there is a limited toolbar
which prevents the ability to edit the design, among other things.
However, if the use presses the <ESCAPEkey, it automatically
reverts to Design Mode.

How do I prevent this?
And then at 8:13pm, ve******@gmail.com wrote in
news:11*********************@p79g2000cwp.googlegro ups.com:
To be more specific, when I click on the "Preview" button on the
database window, pressing the <ESCAPEkey simply closes the form.
But when I use DoCmd.OpenReport with acPreview, the <ESCAPEkey
dumps the report into design mode.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 10 '06 #3
David,

While I can appreciate your desire for an orderly world, I actually
feel that I included enough information in the first post, but,
concerned that there would be no response to my query, based on past
experience, decided to add a reply to push it up the stack.

Rather than simply write "Anyone?," I decided to rephrase the original
question with more specific language. However, were you to parse
through both, you would find that they say the same thing. And anyone
who is capable of answering it would likely realize that.

Thank you though for the opportunity to push this back up through the
stack. Perhaps someone might be able to respond with a resolution to
my issue (for which I searched mightily throughout these groups and the
web in general), as opposed to posting a declaration of a pet peeve.

regards,
marc

David W. Fenton wrote:
This is the kind of thing that annoys me about someone following up
themselves, a post at 6pm and a followup at 8pm that includes
information that should have been included in the original post.

THINK BEFORE YOU POST THE FIRST TIME.

At 5:44pm, ve******@gmail.com wrote in
news:11**********************@m73g2000cwd.googlegr oups.com:
I must be missing something, but I have a report that when it is
opened programmatically as a Preview, there is a limited toolbar
which prevents the ability to edit the design, among other things.
However, if the use presses the <ESCAPEkey, it automatically
reverts to Design Mode.

How do I prevent this?

And then at 8:13pm, ve******@gmail.com wrote in
news:11*********************@p79g2000cwp.googlegro ups.com:
To be more specific, when I click on the "Preview" button on the
database window, pressing the <ESCAPEkey simply closes the form.
But when I use DoCmd.OpenReport with acPreview, the <ESCAPEkey
dumps the report into design mode.


--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 14 '06 #4
I was taught never to scold someone who asks a favour, especially if you don't do it for them.

On Wed, 09 Aug 2006 20:37:03 -0500, "David W. Fenton" <XX*******@dfenton.com.invalidwrote:
>This is the kind of thing that annoys me about someone following up
themselves, a post at 6pm and a followup at 8pm that includes
information that should have been included in the original post.

THINK BEFORE YOU POST THE FIRST TIME.

At 5:44pm, ve******@gmail.com wrote in
news:11**********************@m73g2000cwd.googleg roups.com:
>I must be missing something, but I have a report that when it is
opened programmatically as a Preview, there is a limited toolbar
which prevents the ability to edit the design, among other things.
However, if the use presses the <ESCAPEkey, it automatically
reverts to Design Mode.

How do I prevent this?

And then at 8:13pm, ve******@gmail.com wrote in
news:11*********************@p79g2000cwp.googlegr oups.com:
>To be more specific, when I click on the "Preview" button on the
database window, pressing the <ESCAPEkey simply closes the form.
But when I use DoCmd.OpenReport with acPreview, the <ESCAPEkey
dumps the report into design mode.
Aug 14 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
5842
by: Jeff | last post by:
I have a need to open a report in design mode immediately before opening it in preview, to change the Minimum and Maximum scale on an axis on a chart. This results in a flash of the report in...
8
2968
by: Armando | last post by:
Here's one that's going to leave me bald before long - I have a report (no headers or footers, small detail section) that runs normally when I open it from the database window. When I run it...
6
8168
by: Salad | last post by:
Hi: I have a Bill of Lading template from the printer that I saved as a BMP. I created a new report and in the report's picture property told it the BMP file name. It brought the image in just...
4
2812
by: Gary | last post by:
Hello, I'm hoping someone can shed some light on why my report does not output the same results as shown in preview mode, which is to move the position of a check box based on a field value (see...
2
1315
by: tricard | last post by:
Hello all, I have a report that displays four pieces of data by default, but two of these fields are not neccessary for all people to see. I have made a form that gives the user the choice to...
1
1781
by: vermutmb | last post by:
I'm totally stuck. When I click on the "Preview" button for a report on the database window, pressing the <ESCAPEkey simply closes the report. But when I use DoCmd.OpenReport with acPreview on a...
2
6254
by: Wayne | last post by:
I've been having a click around Access 2007 this afternoon and have discovered some things that range from annoying to alarming. My Access 2003 menu bars, which I, like many others, use...
0
1514
by: davidz | last post by:
My office has adopted Team Foundation Server to track and manage the development and deployment process at our site. I have been asked to modify one of the standard work item reports, "Related...
11
7294
by: Gord | last post by:
When I open a certain report, it runs some code that generates the records that will be displayed in that report. This works fine. When I go to print preview the report it appears that the code...
0
7205
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7287
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7008
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5594
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4688
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3168
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1521
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
746
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
399
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.