Report Layout

G

Guest

Hi

I have book details stored in a table and would like to create a catalogue
in word format for them. I have the following fields in the table -
AuthorFirstName, AuthorMiddleName, AuthorLastName, Title, Description.

I want the layout to look as follows

Authors Names, Title(Same Line)...............
Description.

The problem I am having is some authors do not have a first or middle name
which leaves big gaps in the report and also I would like the title to start
on the same line as the author names but I need it to continue on the next
line if neccesary. How would I achieve this result?

Thanks
 
A

Allen Browne

You can combine the names into one text box, like this:
=[AuthorFirstName] + " " & [AuthorMiddleName] + " " & [AuthorLastName]

Make sure the Name of this text box is not the same as the field names, e.g.
it cannot be called AuthorFirstName.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top