I find myself using a button or other "on-click" control to setFocus on the TextBox for DoCmd.RunCommand acCmdCopy. I supposed one could put the same code in some event (double-click ??) of the TextBox itself. My habit is to keep the code in a separate control's event.

To suppress Ctrl+A for the entire for use the form's KeyDown event.

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

    If KeyCode = vbKeyA And (Shift And acCtrlMask) <> 0 Then
        KeyCode = 0 ' Suppress Ctrl+A
    End If
    
End Sub

Important: In the Events tab of the Form Properties remember to set Key Preview to Yes.

Thanks Kevin and Gregory. I tried Kevin's approach but it didn't work for me. I did find the following approach involving a macro, which seems to work:

Create ==> Macro
Select Submacro when requested to Add new action, then rename it to ^A.
Macro Name = ^A
Macro Action ==> leave blank
Save Macro ==> rename to AutoKeys

Thanks, John. Looks interesting. I haven't tried the earlier technique yet, but yours looks more my speed. I don't know much about macros -- I never use them. Does anyone know it's VBA equivalent?

I've not tried this, but I wonder if you could include an ampersand in the TextBox label to provide a keyboard shortcut way of selecting the field value which could then be "Cntrl-C copied" for pasting elsewhere?

I'm hesitant to mess around any more with this, now that it seems to be working for me. (I don't use macros much.)

John,

If you are worried about messing up what you already have, make a copy of your form and work on that if you need to do some testing. I do this all the time.

Good advice, KR. Ctrl-C in the Navigation Pane, Ctrl-V in the empty build area. Leave the default "Copy of . . ." title as is. Work, then, on this new Form listed in the NavPane. After noodling around, this may be deleted without affecting any of the associated source tables or queries whatsoever.

Thanks again for your help.