show "None" when no data in 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

 

[ajetrumpet]

How is the report being generated?

 

[Banana]

I believe you would use NoData event to catch such possibility and modify the report accordingly.

 

[Rich]

Use a hidden label on the main Report and toggle its Visible property using the HasData method

 

[DCrake]

Simple Software Solutions

Hi

On the RecordSource Property of the field(s) you want to display "None", why not try

= Nz([FieldName],"None")

alternatively set the default value to "None" and then if no data is present then this will be displayed otherwise the real data is displayed.

Code MAster: