SonghaySystem(::)

The Funky Knowledgebase:
Access 97

PROBLEM: Tab Control Does Not Recognize Alt-Key Combinations

Using Alt-key combinations for the Tab Control may not work all the time in Access 97. What I have noticed is when the access keys are pressed, the focus does not change but the application "beeps." This problem is intermittent. It appears to work correctly for tabs with fewer controls on them (three controls or less perhaps).

One work-around for this problem is responding to the KeyDown event:

Private Sub Form_KeyDown(KeyCode As Integer, _
        Shift As Integer)

Dim blnAltDwn As Boolean
        blnAltDwn = (Shift And acAltMask) > 0
    
        With Me
            If blnAltDwn And KeyCode = vbKeyD Then
                'Tab Caption: "Import Ownership &Data"
                .pagImport.SetFocus
            ElseIf blnAltDwn And KeyCode = vbKeyG Then
                'Tab Caption: "Build/Edit Ownership &Groups"
                .pagGrouping.SetFocus
            ElseIf blnAltDwn And KeyCode = vbKeyP Then
                'Tab Caption: "Build Ownership Re&port"
                .pagRpt.SetFocus
            End If
        End With
    End Sub

Using this code, the beeps eventually stop while the Alt-key combinations are pressed.

MSKB Article Q156222 ("ACC95: Access Keys Do Not Work with Tabs on TabStrip Control") states "Microsoft has confirmed this to be a problem in Microsoft Access 7.0. This problem no longer occurs in Microsoft Access 97."

This document was last reviewed on Wednesday, April 28, 1999 at 06:39 PM PDT.

Copyright© 2008 by Bryan D. Wilhite All rights reserved. No part of this material may be used or reproduced in any form or by any means, or stored in a database or retrieval system, without prior written permission of the publisher except in the case of brief quotations embodied in critical articles and reviews. Making copies of any part of this material for any purpose other than your own personal use is a violation of United States copyright laws.

The information provided by Bryan D. Wilhite at kintespace.com is provided “as is” without warranty of any kind. In no event shall Bryan D. Wilhite or any of his affiliates be liable for any damages whatsoever including, but not limited to, direct, indirect, incidental, consequential, loss of business profits or special damages due to material published by Bryan D. Wilhite or any of his affiliates.

SonghaySystem(::)

The Funky Knowledgebase:Access 97

PROBLEM: Tab Control Does Not Recognize Alt-Key Combinations

The Funky Knowledgebase:
Access 97