User text used AS the Calculation

[mike60640]

Is there a way to use the content of a text field (field names typed in as well as & "text" strings) and place it to be used AS THE calculation to generate a text result?

I have a calc field that generates a text string of various fields and some added punctuation and spaces. The user grabs this text to paste in another application. The thing is that this formula may change over time. And instead of having the client "open up" the database to change the calculation, I thought I could create a layout where they might be able to edit a text field which then is used as the calculation. I would provide them with the field names and syntax as well as instructions on the layout.

I tried this but the calc field only returns the text field's content as text... not as the calculated text result. Any thoughts?

[Fitch]

Evaluate

[mike60640]

omg... so simple, why have i not seen that. thanks