+ sign

[lasik]

is there a way to put a "+" before positive numeric fields

also.. is there a way to find a range if the values are reversed? i.e. "40..20" would find the same as "20..40" instead of only finding "40"

thans

[fishma]

You may want to use a calculated field...

For example, if you want to show the "cost" field as positive or negative you could use the following calculated field...

c_t_cost_display calculation(text)

=If(cost > 0, "+", If(cost = 0, "", "-"))

The preceding field definition displays the cost field as positive (+), negative (-), or zero (). I hope this helps you...

The problem is that this field cannot be edited. It gives you the look your looking for though...

Clark!

[This message has been edited by fishma (edited September 19, 2000).]

[This message has been edited by fishma (edited September 19, 2000).]

[fishma]

As for the 40...20 issue:

Set the range into a global text field, and enter find mode. Then parse the field to look for the numbers preceeding and following the elipsees (...), do a comparison between the two, determine which is larger, and reset the field to the proper order (20...40). Perform your find. This is a very quick parse and reset. If you need more details, let me know...

Fishma!