Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Calgary, Alberta, Canada
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    report: field within text

    Using Access 97 in a report, I am attempting to reference (or insert) a "field" in the middle of a "paragraph" of text. I'm sure this must somehow be possible, but as of yet can't figure out how. I need there to be no obvious gaps between words (a true paragraph), and I also need that the paragraph accomodates the "field",(whose data is of varying lengths and the field uses "can shrink" or "can grow") by wrapping. please help!

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report: field within text

    In the control source of the field <font color=448800>="Dear "&[txtCustName]&" this is the text of the body of the letter ...."&[txtAnotherField]&" more text ..."</font color=448800> Set the control to can shrink / can grow. Make the control width the length of the line you desire and wrapping will be achieved automatically. If you need to insert Carriage Returns, they must be added in expression builder view. Hope that helps.

  3. #3
    New Lounger
    Join Date
    May 2002
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report: field within text

    You can add carriage returns/line feeds in the middle of your text easily enough. Try "This is the first line of some text that occupies two lines." & vbcrlf & "This is the second line."

Posting Permissions

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