[AccessD] Disabling Ctrl-A

David,

>Is there a way to check if records are selected
>(any number of records - not just all of them)?

You can always use the Form's SelHeight property:

    If Me.SelHeight = 1 Then
        ' User has selected a single row
    ...

That way, when you trap Ctrl-C, you could allow it for one row, but not
many. You can then allow record selectors, if your users find them useful.

-Ken

PS: Be sure to disable any shortcut (right-click) menus by setting the
Shortcut Menu property to No, or providing your own shortcut menu that
either excludes Cut & Copy, or replaces them with a calls to your custom
functions.


-----Original Message-----
From: David Emerson [mailto:newsgrps at dalyn.co.nz]
Sent: Tuesday, April 05, 2005 1:23 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Disabling Ctrl-A


Thanks Jim,

Another good thought - I could just have the search boxes and show records
as they match the criteria.  However the way we have solved it this time is
to remove the record selectors.  Now with no record selectors, Ctrl-A being
cancelled by Autokeys, and Select all records not appearing in the menu I
think we have covered all bases.

David