Results 1 to 3 of 3
  1. #1
    Grant Shea is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    30

    Custom Reports

    Hi all I would like to create a custom report design that puts the records that i am querying in a specific format. I have attached 2 pdfs that are roughly what i would like the report to look like where the questions and answers are the data in the database.



    Is there any way to do this?

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I would say no, unless you were willing and able to have each row the same height. I thought there'd be a way to do it, but as I wrote I realized that the masking line I refer to below would be fixed, and the control height would vary, so much of the time they would not line up. I'm leaving the answer I was writing to show where I was going with this, but it wouldn't work. One thing you could not have would be the mixed borderlines (solid and dash) like you have. If you have no borders at all, then you could do it. You could have a dividing line for each row though. The practically impossible part is a vertical line that can grow with the section.

    I envision a details section with a drawn line at the top of it, close to your controls, to provide the upper border.
    Your controls would need to look flat and have the Can Grow property set to Yes.
    You would need a horizontal line, same color as your background, same width as your control, placed exactly over the top and bottom border of each the controls. This is to mask the top and bottom control border, and allow the side borders to comprise the vertical lines...

    Your other possibility is a datasheet, but then you'd be printing a form, not a report as you asked.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Grant Shea is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    30
    The colors and formatting are not set in stone. I do not need the vertical line to grow with the section the 4 columns can be fixed width. I just cant stand the default report format that access has.

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

Similar Threads

  1. Creating a custom toolbar floating for reports
    By gangel in forum Programming
    Replies: 3
    Last Post: 11-30-2015, 10:42 AM
  2. Allow user to create custom, filtered reports
    By zzzjoshzzz in forum Access
    Replies: 5
    Last Post: 05-01-2015, 12:33 PM
  3. Replies: 2
    Last Post: 05-27-2014, 11:32 AM
  4. Custom look-and-feel to Access Forms and Reports
    By LindaRuble in forum Programming
    Replies: 1
    Last Post: 01-03-2013, 04:37 PM
  5. Replies: 1
    Last Post: 06-20-2011, 03:56 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