report: field within text

Topic

New Reply

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!

Reply | Quote

Replies

In the control source of the field =”Dear “&[txtCustName]&” this is the text of the body of the letter ….”&[txtAnotherField]&” more text …” 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.

Reply | Quote

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.”

Reply | Quote