text box value on activate (1 Viewer)

Hi
I have a Child Report with underlaying records from a SELECT DISTINCT.
I prints records of prices, I need to show "some_text" if the price is "0".

Which event should I use?
I tried ChildReport On_Activate but could not pull it off.

Many thx

You can show Text in the 0 value field itself when the field value is zero.

Display the Property Sheet of the Report Text box.

Set the following format string in the Text Box where 0 value is appearing:


Change the value ZERO to the required value you want to display on the Report.

There are four segments in the format property.

First segment displays positive values in the set format e.g. #.00 displays values with two decimal places.

Second segment (ignored here) will display negative values in the set format, if present.

Third Segment displays the Text in place of 0.

Fourth Segment displays the set text, if the field value is Null.

You don't need to run any Event Procedure in this case.

Thank you very much.