Display data in a Report

[BSC5905]

In a report I have a field that contains no data because “Allow Zero Length” is set to yes. This I expected. Is there a way on the report or the query which the report is based on to create an expression that will display “N/A” or any other text that I choose to be displayed when there is no data in that field when I generate my report?

 

[rjoubert]

In your report field's control source, enter the following expression (Replace [Field] with the name of the field from the table or query)...

= IIf(IsNull([Field]),"N/A",[Field])

 

[Remou]

You can use IIf:

[tt]=IIf(Trim([Field1] & " ") = "", "N/A",[Field1])[/tt]