Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Montreal, Quebec, Canada
    Posts
    209
    Thanks
    12
    Thanked 1 Time in 1 Post

    Formatting Reports Like Table View (Access 2007)

    Having created a tabular report from a Table, using the Report Wizard, is there a way of formatting it so it looks like a print from the table with gridlines and shading on alternate detail lines?
    David P - The Truth Is In Redmond

  2. #2
    New Lounger
    Join Date
    Mar 2013
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lightbulb Lots of formatting

    Quote Originally Posted by dpollock View Post
    Having created a tabular report from a Table, using the Report Wizard, is there a way of formatting it so it looks like a print from the table with gridlines and shading on alternate detail lines?
    I'm not sure what you are up to, but try these things:

    -----------------
    Make sure all text boxes fit right next to each other in the detail section; no empty space anywhere across the width.

    Make sure you have dark/black borders on all text boxes.

    Make sure the height of the detail section is exactly the height of the text boxes, which all must be the same height and aligned with each other "to the top"

    Make the text boxes fill as "transparent"

    Turn on alternate row color in the detail section of the report.
    -------------------

    That should about do it. It's at least a good start to making the output look like a datasheet view.

    You might try putting a subreport into the detail section, with the subreport being a datasheet view of a query or table. I'd have to fiddle with that to see if the idea works, though.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •