How to print 2 fields in 1 column ?

[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

 

[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)

 

[Joseph Meehan]

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

That is not hard at all using a report. Have you tried using a report
yet?

We don't know much about what you really want to see printed so it would
be difficult to give specific instructions. I suggest you try and do your
best with the report wizard and then if you get stuck, come back and tell us
what you did do and what the results are and how you need the changed.

 

[Larry Daugherty]

make the record source for the textbox:

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

HTH

 

[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

Thank you all. It's OK now.