show "None" when no data in the sub-report

[Associates]

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

 

[Marshall Barton]

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"