S sammy16 Registered User. Local time Today, 19:33 Joined Aug 6, 2004 Messages 11 Oct 19, 2004 #1 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
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
pdx_man Just trying to help Local time Today, 11:33 Joined Jan 23, 2001 Messages 1,346 Oct 20, 2004 #2 You can put it in the underlying query or in the Control Source of the report. Check out the NZ function in Access Help.
You can put it in the underlying query or in the Control Source of the report. Check out the NZ function in Access Help.