Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Sweden
    Posts
    11

    Question Unanswered: ACC2000 - Reports - linebreaks

    Most of the time you really want to keep words together and you're happy that Access does this. This is not the case for me. I actually want the words in this particular control in my report to be split like so:

    averylooo
    oongword

    Of course, one way - though probably a bit inaccurate - would be to calculate (control is x twips wide, this corresponds more or less to y characters) where to insert a vbCrLf in the loooong word ( 'looo' & vbCrLf & 'ong' ) but of course I'd rather not. Suggestions?

    TIA

    // Paul

  2. #2
    Join Date
    Mar 2004
    Location
    Sweden
    Posts
    11

    Exclamation Solution

    Well, I didn't find a way to instruct Access to do this, but simply replacing spaces with alt + 255 and hyphens with alt + 196 effectively turned my string into a single word and thus got to be displayed just as I wanted it to be.

Posting Permissions

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