Results 1 to 2 of 2
  1. #1
    dara is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    1

    Don't show lookup list options in report

    Hi there
    I am newish to Access and now I have my database setup I am trying to create a report on my main table. The problem is that it shows all the options in my lookup lists for each entry,I only want it to show the selected one. This sounds so easy to do but I can't work out how to do it?
    Can anyone please help?

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    For each such control on your report, the Control source for each such option conrol should be

    Code:
    iif([ControlName]=True,[ControlName],""
    the brackets "[" and "]" are mandatory, indicating a report field.

    The "conditional if" statement reads:
    Code:
     If control "ControlValue" equals Truethe display ControlName's value, otherwise (else) display nothing (hide it). 

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

Similar Threads

  1. Replies: 2
    Last Post: 01-25-2010, 09:23 AM
  2. Need report to show dates
    By Brian62 in forum Reports
    Replies: 2
    Last Post: 11-20-2009, 12:05 PM
  3. Invisible LookUp Data List
    By aaghd in forum Access
    Replies: 3
    Last Post: 07-28-2009, 02:35 PM
  4. Replies: 5
    Last Post: 05-02-2006, 11:25 AM
  5. Lookup or list field: how Do I not show all records
    By scott munkirs in forum Forms
    Replies: 4
    Last Post: 04-13-2006, 12:44 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