Fields inserted into Detail area do not display in Print View

[snowboarder234]

How is it possible to get the information inserted into the DETAILS to display? It only shows in design view.Thanks.

[pbaldy]

When do my royalty checks start arriving?

For starters, the detail section seems unusually tall. I would typically drag it up to just below the fields. Does the table/query return records, and is there data in those fields? Offhand, what you have looks correct.

[snowboarder234]

I think I may be too new to this to answer your questions -- but I'll try. This report is drawing from information in a invoice query. The record source is qryInvoice and here is a screen shot of the query with the data in the fields:

[pbaldy]

That looks okay. Can you post the db here?

[snowboarder234]

You'll have to walk me through that one -- how do you upload a database to a forum?

[pbaldy]

If you click on Reply to Thread or Go Advanced you'll see a Manage Attachments button below where you type. Typically if you compact/repair then zip it should be small enough to attach.

[snowboarder234]

Here is the zipped and repaired/compacted file.

[pbaldy]

Okay, that took a minute to find. First I'd shrink up the detail section, which I assume is the look you want anyway, then change the Force New Page property of the section to None. I think your detail data is displaying, it's just on the next page because of that setting. See attached.

[snowboarder234]

Thank you. That worked! The detail information now shows in the print preview.

Are you available for another question: This is the error message I get when trying to concatenate the first and last names in the qryInvoice file. Thanks again. I appreciate the help. The error message seems simply enough -- it appears as though it could be resolved be eliminating the duplicate first/last fields in the other tables. But this is my first db and I'm afraid to start deleting anything.

[pbaldy]

The error is because you have a field named "First" in more than one of the tables/queries in the FROM clause (you'll get the same error on "Last". The solution is to disambiguate it by specifying the table/query:

FullName: TableName.First & " " & TableName.Last