Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049

    Unanswered: Access 2007 Preview Escape After Zooming.

    Hi all

    I have an interesting dilemma. I have many converted databases that exhibit the following behaviour.

    * Open a report in print preview.
    * Press ESC (report closes)
    * Open a report in print preview.
    * Zoom in by clicking on the report.
    * Press ESC (nothing happens) ◄- this is the problem I want to fix.
    * Zoom in, zoom out, nothing now allows you to close the preview except CTRL-F4 now. The user is stuck.

    There is no code behind the report other than your usual, OnNoData type code and a DoCmd.Maximize during OnOpen. Certainly nothing that messes with report properties.

    I can watch carefully, notice that the close button and control menu are available in the report before I zoom, but not after. Nothing seems to bring this back.

    I can even confirm that if I hide the report instead of closing it, then "open" the report, ESC will work again... provided no zooming goes on before ESC is pressed.

    If I switch to another application, then back to Access, ESC works again... again, unless zooming happens.

    I tried re-creating the report from scratch to see if it was a conversion issue, but alas, even a new report does this.

    I have also tried creating a new database, importing all the objects from my existing one. Nothing changed.

    I've tried making the Close Print Preview button available on the Quick Access Toolbar but this is too user - unfriendly for my liking.

    What I am currently doing to workaround the problem is to detect the ESC key with KeyDown and using SendKeys (yuk!) to send CTRL-F4, but although this fixes it IF the user zooms, if they do not, one ESC from the user will now not only close my report, but it also closes my reporting dialog. I set Cancel = False for the Cancel button on my reporting dialog, but I'd rather not do that if I can avoid it.

    There HAS to be a better way!

    Any ideas? Anyone else experienced this and figured a way out of it?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Bad news....

    I just went into two of my apps (2003 SP3) and all of my reports will close normally with the escape key, whether the report has been zoomed or not.

    Sorry, Stu
    --If its free, take it for what its worth!

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Which means there MUST be a solution!!

    All the databases affected are CONVERTED. So I suspect it's some property somewhere that's making this behaviour occur.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    No-one has encountered this? Bit surprising.

    I guess I'll have to get them used to clicking a button on a toolbar rather than what they're already familiar with. Users don't like change though!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •