Results 1 to 9 of 9
  1. #1
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340

    Access Issue - selecting row or column

    This problem is in Access 2003, unsure about later versions. With a datasheet view Form
    trying to select just one column or row by clicking the fieldname or leftmost grey area becomes impossible. Always more than one row or column is highlighted.


    I can fix it (until it happens again) by closing Access and re-opening but is there any other way ?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    sounds like you have a corruption in the db - suggest compact and repair. It may also be that you have some code running which has not been closed properly or is poorly written and leaving access in an unstable state.

  3. #3
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340
    That's probably the case, especially as code can be in a testing state.
    Next time it happens I'll try C&R and see if that works and no need to reboot Access.
    Thanks.

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    if any unbound fields exist - they might cause similar behavior in a continuous form or datasheet view......

  5. #5
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340
    I have some unbound fields. Is it a bug in Access and just have to accept it ?

  6. #6
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    It is not a bug. If there is an unbound text box in a continuous form row/record - it is not anchored to any specific record; therefore any action with it is going to span all records. It can be unsettling. In your table, add a field so that the control on the form can be bound.

  7. #7
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340
    It's not normal behaviour and is intermittent. Then you need some corrective action. Doesn't effect all records, instead a random number that can change with every click.
    It also happens to bound controls. VIP may be right about code running which has not been closed properly or is poorly written, as it's more prevalent during code development or testing.
    Once it occurs, you're stuck with it. It hasn't happen since to try a C&R. Be nice if that did work and no reboot needed.

  8. #8
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    My post only was about unbound controls on a continuous form. If you have bound controls changing values the only legitimate way that I can think of is with VBA code in an OnCurrent or Dirty event - possibly another event, but in any case via VBA code. If you are certain there is no such code then corruption would be the only other candidate. Delete form, compact/repair, remake new form.

  9. #9
    Middlemarch is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2015
    Posts
    340
    OK. Doesn't seem to be that common, but happens here quite often. I'll put it down to 'one of those things; and try 5 C+R or reboot. The latter always fixes it. I've not had to remake any Form. Cheers.

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

Similar Threads

  1. Replies: 4
    Last Post: 08-01-2015, 01:29 PM
  2. Replies: 15
    Last Post: 07-30-2015, 01:38 PM
  3. Replies: 5
    Last Post: 10-15-2014, 01:12 PM
  4. Replies: 19
    Last Post: 11-07-2013, 11:10 AM
  5. sales DB selecting column and column range
    By pher77 in forum Queries
    Replies: 3
    Last Post: 06-11-2011, 04:04 PM

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