merging data onto a report

[jjohnston]

I need to use memo boxes for a report card program. In the report I would like to have two seperate memo boxes appear as one box regardless how much text is entered in each of the records. I don't know how to build the expression for memo boxes (can do it for text boxes, but have to use memo boxes)
Thank you.

 

[jstutz]

So I can better understand your dilemma, why won't a text box suffice for your application?

The reason I ask is because, unless I am mistaken, on a printed report, there really isn't a difference between a text box and a memo box. Even on a form where the user could interact with the control, the basic difference between a text box and what Access uses for a Memo box is that the Memo box has the Vertical Scroll bars turned on in the properties, whereas a textbox by default does not. You can, however turn on the vertical scroll bars on the properties menu for a regular text box.

I think you should be able to concatenate the two fields into one control by creating an unbound text box and set the control source '=[Field1] & " " & [Field2]' as you normally would.

Perhaps I don't understand your question, so if this didn't answer it, let me know and I can try again!

Jamie



[This message has been edited by jstutz (edited 05-19-2000).]