Hi,

I have a report that has a sub-report in it. I was wondering if it's 
possible to do the following.

when one of the fields in the sub-report has no value or data, i would like 
that field to show "None". If there are values or data, then shows the data 
otherwise just "None". How do i do this in Access 03?

Thank you in advance

Associates wrote:
>I have a report that has a sub-report in it. I was wondering if it's 
>possible to do the following.
>
>when one of the fields in the sub-report has no value or data, i would like 
>that field to show "None". If there are values or data, then shows the data 
>otherwise just "None". How do i do this in Access 03?


If the value is Null when there is "no value", then you can
just use a custom format property setting in the field's
text box.  E.g.  if the field is an integer field, the
format might be like
	0;;;"None"
for a Text type field:
	@;"None"


-- 
Marsh
MVP [MS Access]