A filed with Numeric format designated to store amount cash dividends paid in currency format. This field, however, for sometime is empty if there was no dividends was paid. But keeping the field empty might be misleading for the user. I decided to replace the empty value with "No Dividends for This Year". Becuase the field is in currency format I can't show the text in it.

 

Is there a way to make the field shows a text if the value is empty without afecting the numeric values for other years that table.

Here the ways is, make a field of type calculation, set if numeric field is empty, then calculation field with the msg like "This is msg". Keep that calculation field just below the numeric field, and set the background of numeric field to none. Then if number will be blank, a msg will be prompt, and if field no data  will be visible.

 

For more help, please find the attachment of file.

Untitled.fmp12.zip