but when the button is clicked, it does not seem to highlight all the text, it flickers before the start of the first character as the highlighting is from right to left, and sometimes I wonder if all the text have been selected.
Private Sub cmdCopy_Click() ' This procedure runs when the Copy button is clicked. On Error GoTo Err_cmdCopy_Click ' Set focus on the results. Me.txtResults.SetFocus ' Copy the results to the clipboard. DoCmd.RunCommand acCmdCopy Exit_cmdCopy_Click: On Error Resume Next Exit Sub Err_cmdCopy_Click: MsgBox Err.Number & " " & Err.Description, vbCritical, "cmdCopy_Click" Resume Exit_cmdCopy_Click End Sub
From novice to tech pro — start learning today.