Formatting a List Box With Two Columns in a report (1 Viewer)

I got a Listbox in my report that displays LAstname and First name like so:


Lastname | Firstname

Basically is shows the two columns (fields) next to each other.

Is it possible to change the format so I can display it as,

Lastname/Firstname

I cant seem to figure out how to do this.

Second Question:

Is it possible to set the default number of Reports to be printed?
I need to be able to print 4 copies of the report each time. I dont want the user to have to hit print 4 times.

Thank you in advance.


sincerely,
Jordan

Jordan,

As long as it is a multi-column listbox, I think Access has the
final say so as to how it will be printed.

A work-around would to make its row source:

Select fldA & "/" & fldB From YourTable;


No help on the second problem.

hth,
Wayne

Thanks Wayne I got it

What I did, was edit the Query adding a second field concatanating the two fields like so.

LastName & " / " & Firstname

So simple and it worked

Thanks for respoding