Results 1 to 7 of 7
  1. #1
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123

    New lines in text box

    Hi All I have a report that looks ok but it's bugin me when I have a renentry and the chart run is longer than the width is starts a new line but what I would like to do is

    Reentry: 1, 2, 3, 4, 5, 6, 6 Etc then start the next line like
    7, 8, 9, 10

    Instead of:
    Reentry: 1, 2, 3, 4, 5, 6, 6


    ............7, 8, 9, 10

    The . are so the furum keeps the format I want

    The report is to big to attach so please view it here:
    https://databasedreams.createaforum....msg269/#msg269

    Look at position 6 abba gold

    thanks mick

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    That would require concatenating all data into a single textbox. So that "Charted: 02/08/2008 | Entries: 6 | Chart Run 85, 51, 28, 34, 49, 82" is just one long string, not separate controls bound to fields. Or in your example: "Reentry: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10".
    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
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Quote Originally Posted by June7 View Post
    That would require concatenating all data into a single textbox. So that "Charted: 02/08/2008 | Entries: 6 | Chart Run 85, 51, 28, 34, 49, 82" is just one long string, not separate controls bound to fields. Or in your example: "Reentry: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10".
    Thanks june7 All the stats are in one text field from charted to last reentry

    Mick

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Then I don't understand issue. Which example represents actual data - the image or the narrative? If that is your project in image then it looks you have the desired output. Please clarify what you are asking for.
    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
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Sorry that was

    I want it to look like this

    Reentry: 1, 2, 3, 4, 5, 6, 6
    ............7, 8, 9, 10
    With each line after the Renetry: line I want to try and incremented them so they start where the 1 is then when there is another reentry then that line should start at the edge of the text box.

    sorry made a mess of the original disription.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You want to break with new line whenever a number is duplicated?

    I expect that would require VBA custom function. So could end up with something like:
    Code:
    Reentry: 1, 2, 3, 4, 4,
    
    5, 6, 6,
    7, 8, 8, 9, 10
    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.

  7. #7
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Quote Originally Posted by June7 View Post
    You want to break with new line whenever a number is duplicated?

    I expect that would require VBA custom function. So could end up with something like:
    Code:
    Reentry: 1, 2, 3, 4, 4,
    
    5, 6, 6,
    7, 8, 8, 9, 10
    Think I can sort it now I'll post a link to the report.

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

Similar Threads

  1. Replies: 1
    Last Post: 10-12-2016, 02:20 PM
  2. Lines in a text field that can grow
    By Hasher in forum Reports
    Replies: 3
    Last Post: 12-10-2014, 11:30 PM
  3. Replies: 5
    Last Post: 11-24-2014, 04:51 PM
  4. Replies: 16
    Last Post: 04-01-2014, 12:22 PM
  5. Replies: 3
    Last Post: 05-16-2012, 02:56 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