I can't imagine this is possible, but, I see the topic here, so I'll ask.

I have a table that defines various terms for paying royalties. Basically, it's set up as:

person

Rate type (value list: fixed, percentage)

rate Amount (such as $1675 and 3.875%)

Now, I know very well that the rate amount can happily hold 1675 and .03875

But, when I print the report for anyone, they need to see the info as $1675 and 3.875%

Suggestions?

I looked at Format->Conditional and that helps me a bit... I could make anything > 10 be formatted in bold, for example... but that isn't ideal.

Thank you !

Look at Format > Number… instead.

Let me try to be clearer with my question.

I know how to format a field.

However, I want the format of the field to vary, depending on the contents of another field.

I want the format to be % if the Rate Type is percentage

I want the format to be currency if the rate type is "fixed"

Let me try to be clearer with my question.

That always helps...

No, it's not possible. You will need to add a calculation field with a text result, and do your own formatting there. Or use two separate fields to begin with.

EDIT:

Maybe this can work for you: put two instances of the same field on the layout (overlapping), and format them conditionally to shrink to font size 1 if the record is not their type.

Edited April 28, 200916 yr by Guest

Here's a variation of the same idea - seems to be working.

ConditionalNumberFormat.fp7.zip

Hello -

Your solution is very clever, and works perfectly and I can't well to tell my husband (who works in Approach) that we solved it.

I knew there had to be a way -

Thank you for 'thinking outside the box' with me -

Marion

Edited April 28, 200916 yr by Guest