Results 1 to 4 of 4

Thread: complex report

  1. #1
    Join Date
    Feb 2012
    Posts
    6

    Unanswered: complex report

    I am trying to produce a report in paragraph format, 1 record per page. Some of my fields are memo data type. Each memo field varies in size from 50 to 300 characters. How do I anchor the fields to each other and not to a physical location on the page, so regardless of the length of each one they read properly without huge gaps between them to accommodate for the largest of them.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I'm not clear on what you have, but how about a single textbox that concatenates the fields together, like:

    =Field1 & " " & Field2 & " " & Field3
    Paul

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    You can set the "CanGrow" and "CanShrink" properties of the text boxes to accommodate the variable values that they can contain.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by pbaldy View Post
    I'm not clear on what you have, but how about a single textbox that concatenates the fields together, like:

    =Field1 & " " & Field2 & " " & Field3
    or perhaps better yet insert a carriage return

    =Field1 & vbcrlf & vbcrlf & Field2 & vbcrlf & vbcrlf & Field3

    which is the same as
    =Field1 & chr$(10) & chr$(13) & chr$(10) & chr$(13) & Field2 & chr$(10) & chr$(13) & chr$(10) & chr$(13) & Field3

    you'd need to do it twice to end the current line and then add a line for spacing
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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