Can you really use Display String formula to test for NULL

[Former Member]

I am trying to manipulate the Display String of a field throught the Format Editor. If a field is null, it should display "N/A", or "No data given", or anything else appropriate I might choose.

I can't get this feature to work and I'm wondering if there's a bug here. I'm using the following formula:

if (isnull() or trim() = "")

then "N/A"

else

Am I doing something wrong or is there a better way to do this?

[Former Member]

Thank you both for your fast replies, they are helpful. Yah, I should have mentioned that I knew I could create a formula, I apologize for not doing that before. I was just hoping there was a way to avoid that solution, which might entail a good deal of formula building if you are retrieving 50 or more dbfields.

I won't whine about it, I'll commence typing (er, cutting and pasting) asap. )

[Former Member]

Hi Adriane

The other way to display "N/A", or "No data given" if a field is null is using a formula with if -else statement as follows:

whileprinting records;

if (isnull() or trim () =" ")

then "N/A"

else

Please let me know if this helps.

Thanks

Poonam Thorat

[former_member260594]

Adriane,

Formatting formulas will not evaluate null.

Instead create a formula object similar to;

If isnuul() then 'N/A' else ''

Place the formula in the same position as the database field.