Displaying texte in a number field 1

[keysol]

Hi,
I would like to display from time to time text in what is normally a number
calculation field.
Using the if statement, I would like to test a certain condition
(mathematical) and if it is false display text such as "N/A" instead of the
usual numerical result.
I've tried without success. I do notice that the test seems to work and when
I depress my mouse pointer on the field in question the text appears (N/A).

How do I make it so that the "N/A" appears on screen and when printed
(without using the mouse of course) ?

Gerr
keysol@videotron.ca

 

[jware]

Keysol,
The following should solve your problem.
1. I defined a Calculation text field "TestNum Display."
IF(TestNum > 0, NumToText(TestNum), "N/A&quot
2. Make sure the "Do not evaluate if all referenced
fields are empty" is unchecked. Also the results must
be text.
3. Place field TestNum Display on your layout.

Of course you can use whatever names you like for the fields.
Good luck,
Jware