Results 1 to 5 of 5
  1. #1
    robs23 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    109

    Don't allow cursor placing in datasheet view


    Hi,
    I can't seem to find the answer how to prevent a user from placing a cursor into a cell.. Of course I have had disabled changes and such, but still, when you click the cell it place the cursor there as if for you to edit the value. It won't edit (as it's disabled) but still, it looks weird, I don't like that. Can I change this behaviour somewhere?
    Also, if the cell is in 'date' format, it shows this date selector next to the cell (a kind of button with a calendar icon). I disabled the edition of this field so it doesn't make any sense do display this selector, especially since it overlaps the next cell. How can I get rid of it?

    Thanx,
    Robert

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Wish were possible but I have never seen any method to accomplish preventing click into control, locked or not.

    Change the ShowDatePicker property to Never.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe instead of DS view you could use Continuous View and set the property for the control Enable = False. You may want to adjust its color etc. after Enabled = False.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Locked Yes controls can be still be clicked into, Enabled No controls cannot.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    robs23 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    109
    Thanks guys! The date picker does not pop up any more I've given a try to the 2nd pointer (enabled to No) and seemingly it worked but it also messed up with my event triggered by cell's double click.. Besides, I was kind of hoping for the solution that wouldn't place the cursor, but select the row clicked just as nicely. Anyway, I got my answer so thanks once more!

    Robert

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-28-2014, 10:13 PM
  2. Replies: 3
    Last Post: 08-18-2013, 09:14 PM
  3. Replies: 6
    Last Post: 11-21-2012, 05:10 PM
  4. Replies: 16
    Last Post: 09-12-2012, 08:39 AM
  5. Datasheet View
    By Evgeny in forum Programming
    Replies: 6
    Last Post: 04-28-2010, 10:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums