Results 1 to 3 of 3
  1. #1
    Robyn is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Mar 2015
    Location
    Melbourne, Australia
    Posts
    2

    Position of fields on a report

    Does anyone have any suggestions for how I can overcome this problem on a report?



    It’s set up in tabular form. One column has a lot of data (memo field), causing the report to need many pages (80). Four other fields have very little data, but take up space across the page. I’d like to arrange it so that I have 2 fields together, one on top of the other (twice). Then field 3 can be a lot wider.


    Field 1 Field 3 Field 4
    Field 2 " Field 5
    "
    "

    But when I put them in this position 1 and 4 sit at the top of the row and 2 and 5 sit below 3, causing me to need even more pages.

    Field 1 Field 3 Field 4



    Field 2 Field 5

    I could concatenate fields 1 & 2 and 4 & 5 , but I’d have an expression that told the second field to start on a new line. Is that possible?


    By the way, fields 1 and 3 are already concatenated from 2 fields each.


    I'm using Access from Office 14 - it's not in the list for registering.


    Many thanks in advance,
    Robyn

  2. #2
    Robyn is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Mar 2015
    Location
    Melbourne, Australia
    Posts
    2
    Sorry, the formatting of my "diagrams" didn't come across. Hope the text is enough.

  3. #3
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,844
    not familiar with Office14, but sounds like you have an enforced layout - suggest in design view, highlight the controls and click on remove layout in the design tab

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

Similar Threads

  1. Replies: 17
    Last Post: 07-15-2014, 06:17 AM
  2. Replies: 3
    Last Post: 05-06-2014, 11:38 PM
  3. Replies: 1
    Last Post: 02-27-2014, 07:59 PM
  4. Add decimal in position
    By BrianF in forum Import/Export Data
    Replies: 4
    Last Post: 04-15-2013, 12:18 PM
  5. Replies: 1
    Last Post: 02-23-2011, 05:11 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