Results 1 to 3 of 3
  1. #1
    cassidym is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010

    Hide Duplicates

    Building a report in Access 07 and I don't want duplicates in the first column. So I click on the data item in design view but that highlights both the data item and the label at the top of the report. I open the Property Sheet and select YES by Hide Duplicates but, when I open the report, the duplicates are not hidden.

    Is there someway to isolate the data item and not highlight the lable and actually hide the duplicates?


  2. #2
    LillMcGill is offline Dagny fan
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Oct 2010
    Southern USA
    Click the textbox and then click the Remove button on the Ribbon to remove the layout. I'm using version 2010, and I am sure this button was moved, so I can't tell you exactly where it is in 2007. I think you had to be in Layout View.

    If this doesn't work, click the textbox again and look for a tiny icon that looks like a square with a plus sign in it, near the label. Click this icon and then click the Remove button.

  3. #3
    cassidym is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Tried this and couldn't get it to work. When you say 'layout', are you referring to Layout View. I learned Access on 03 and am finding 07 to be maddening.

    In 03, to prevent duplicates in a report, you simply clicked on the text box, opened the properties window and selected 'yes' by Hide Duplicates. Consequently, in a column in a report, data would not repeat. But, in 07, I click the text box and open the property window, select yes by Hide Duplicates and nothing happens. The data in the column repeats. Grrrr

    Would appreciate any advice.


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

Similar Threads

  1. Hide Duplicates In Look Up Form
    By PonderingAccess in forum Queries
    Replies: 2
    Last Post: 09-30-2010, 12:23 PM
  2. duplicates
    By Roberta in forum Queries
    Replies: 5
    Last Post: 09-10-2010, 07:31 PM
  3. combo box - no duplicates
    By pkg206 in forum Access
    Replies: 1
    Last Post: 11-12-2009, 10:41 AM
  4. Deleting Duplicates
    By TundraMonkey in forum Queries
    Replies: 4
    Last Post: 09-08-2009, 07:13 AM
  5. Hide Duplicates with Group Headers
    By diwin in forum Reports
    Replies: 0
    Last Post: 03-26-2009, 09:32 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