How to print 2 fields in 1 column ?

A

arnicot

I need to print a book order form on which the book title and the author
must appear in the same column, one above the other.
i.e.

"The best man"
by: John Martin
"The best woman"
by: John Martin

How is it possible to manage that?
Thanks
 
D

Douglas J. Steele

Two possible solutions.

Create a computed field that concatenates the two fields in a query, and
then use the computed field in your form. You'd do this in the query grid by
picking an empty cell in the Field row and typing something like NewField:
[BookTitle] & Chr$(13) & Chr$(10) & [Author]. You'd then use the query with
your form, and put [NewField] where you want the text to appear.

Another approach would be to set the control source of your text box to
=[BookTitle] & Chr$(13) & Chr$(10) & [Author] (including the = sign)
 
L

Larry Daugherty

make the record source for the textbox:

="" & [BookTitle] & "" & vbcrlf & "by: " & [Author]

HTH
 
A

arnicot

arnicot a écrit :
I need to print a book order form on which the book title and the author
must appear in the same column, one above the other.
i.e.

"The best man"
by: John Martin
"The best woman"
by: John Martin

How is it possible to manage that?
Thanks
Click to expand...
Thank you all. It's OK now.
 
Top