I'm pretty sure I know the answer to this but maybe someone has a brilliant workaround. Or maybe I don't know the answer.

Anyway, is it possible to have more than one auto-enter calculation acting on a field? Example: I'm using a phone format auto-enter calculation that I like very much and would hate to remove it. I also like the idea of using an auto-enter calculation to show field labels in an empty field:

Case(IsEmpty(field); "field label text"; "")

Is it possible to have both calculations acting on a single field?

Abbe Lougee

How about:

Case( IsEmpty ( field ) ; "field label text"; )

Haven't tested try this?

Let(

-text = "field label text";

_format= ;

_label = Case (isEmpty( field ) or field = _text ; _text ; _format )

];

_label

)

Edited October 7, 200817 yr by Guest

This works, thank you! And I really should have been able to work it out for myself. But I learned a little that I can apply (or try to apply) in other circumstances.

I'd love to make this work, but every time I enter the calculation, FM returns the error "The specified field can not be found" referring to the variable '_format'

I'll keep playing around with this because it should work. Wish I had figured this out myself...

Abbe