I have designed my report and I can view or print individual reports as long as every field contains data.

Sometimes there is no relevant data and the field has to remain blank, particularly as it could have a knock on effect on a concantenated query.

The form/report is poulated by data held in combo boxes from other tables.

What do I need to set in the properties of the fields in the tables to tell my form/report to ignore blank fields?

I hope that makes sense!

Assuming your report data is created from a query then I would assume it is because of the relationships defined between the tables in the query.

If you have the relationship defined as 'equal from both tables' then you will get the discrepancy you are experiencing. Because there is no data in a corresponding table (or combo box look-up table) the main record will not display.

If you redefine the joins as left-joins, or, 'from this table and all from the other table' then you will populate the data set the way you want. The trick here is not creating circular references.

Keep in mind that redefining the relationships in the query is not rewriting the relationships of the database - so have no fear in performing this task for your reports.

HTH,
-dK

Thanks for the response and help - issue now solved

Great!

And oh yes ... welcome to AWF!

-dK