Results 1 to 6 of 6
  1. #1
    Michelle Roche is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2015
    Posts
    2

    Access Report Design

    I have a combo box in my report design and I would like it to display "true" values as a list with check boxes

  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,772
    Why? Reports are not intended to be interactive. Report in print preview certainly is not. The combobox list will not display in paper printout.
    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
    Michelle Roche is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2015
    Posts
    2
    No I do not want it to be interactive, I would like it to display for ease of reading. Currently the box shows all the true values like this : Apples, Plums, Pears - I would like it to show (check) Apples etc.

  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,772
    Sorry, combobox will not display dropdown list on a report. Why is the check mark important? If the value shows in the box then it is checked.

    I NEVER use multi-value fields.
    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
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    I believe you should be using a sub report

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    I am not sure a subreport is needed. If you want the multiple items listed vertically, then the report RecordSource must be a query that expands the multiple values to individual records. https://support.office.com/en-us/art...3-B6624E1E323A

    Then use report Sorting & Grouping features to organize the data.
    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.

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

Similar Threads

  1. Table Design -- want to avoid a design that creates blank fields
    By snowboarder234 in forum Database Design
    Replies: 4
    Last Post: 10-08-2012, 10:13 AM
  2. New to Access, Need to Design Database for Non-Profit
    By oatsybob in forum Database Design
    Replies: 1
    Last Post: 10-01-2012, 04:47 PM
  3. Replies: 23
    Last Post: 08-13-2012, 04:47 PM
  4. [Access 2007] fix bad design
    By Zoroxeus in forum Database Design
    Replies: 1
    Last Post: 04-17-2012, 05:23 AM
  5. Access Report Design Requirement
    By nizam in forum Access
    Replies: 4
    Last Post: 06-24-2011, 05:05 PM

Tags for this Thread

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