Results 1 to 3 of 3
  1. #1
    thepuppyprince is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    1

    Fields repeat in column filter


    There is some sort of bug in my database where fields are repeated in the drop down filter menu in datasheet view(see below). The value of the field itself is not repeating, but it is being filtered as if it were. Has anyone ever seen this before or have any idea how to troubleshoot? I tried deleting and adding the entries, but that does not fix it.
    Click image for larger version. 

Name:	screenshot.jpg 
Views:	6 
Size:	79.2 KB 
ID:	10718

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    No, never seen this.

    Would have to review the db. If you want to provide, follow instructions at bottom of my post.
    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
    ieuan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Location
    Philippines
    Posts
    5
    Have you pasted the data from an external editor such as Word? Make sure they do not have carriage return values.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-17-2012, 11:42 PM
  2. Replies: 30
    Last Post: 08-15-2012, 02:25 PM
  3. need to filter a column in a subform
    By gregu710 in forum Forms
    Replies: 6
    Last Post: 02-21-2012, 05:19 PM
  4. filter report by query row and column
    By usmcgrunt in forum Access
    Replies: 4
    Last Post: 04-13-2011, 06:52 PM
  5. Filter form by column
    By smikkelsen in forum Forms
    Replies: 10
    Last Post: 04-27-2010, 10:46 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