<div>
No points, please.<br />
<br />
As Gustav said, the Eval() function will do the job.<br />
<br />
You could have your users enter the function in a text box, like:<br />
<br />
A + B ^ .05<br />
<br />
Then you could use the Replace() function to replace instances of each of the variables:<br />
<br />
strEval = Replace(me.txt_Eval, &quot;A&quot;, &quot;Str(A)&quot;)<br />
strEval = Replece(strEval, &quot;B&quot;, &quot;Str(B)&quot;)<br />
...<br />
<br />
Then you could store that value and use it Elsewhere in your code.
</div>


<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts!<br />
<br />
I'm wondering if there is a way in which I could take a series of variables and allow users to construct custom forumlas off those to run calculations. <br />
<br />
So for example, I may have 4 variables -- &nbsp;A, B, C, D. &nbsp;Would there be a way I could do an 'expression builder' where I could -say- let users build a formula such as &quot;&nbsp;A + B ^ 0.5 &quot;&nbsp;and then use that formula elsewhere to display data?<br />
<br />
Maybe a sub form that allows logic to be built and then on save VB updates the variable?
</div>
</div>


Hi Experts!

I'm wondering if there is a way in which I could take a series of variables and allow users to construct custom forumlas off those to run calculations. 

So for example, I may have 4 variables --  A, B, C, D.  Would there be a way I could do an 'expression builder' where I could -say- let users build a formula such as " A + B ^ 0.5 " and then use that formula elsewhere to display data?

Maybe a sub form that allows logic to be built and then on save VB updates the variable?

Formula based off field - MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.