Is there any way of displaying a message in a field on a report if there is no value being passed from the query?

If so would you just put the code in the control source of the field in the report?

Cheers

You can put it in the underlying query or in the Control Source of the report. Check out the NZ function in Access Help.