How to Evaluate Math Expression Stored As Text

A

Altemir

I have a text form control whose values contain mathematical
expressions. For example, the control might contain the string value
"2*4+6". Is there an easy way to evaluate this value mathematically
and display the result (e.g., "14") in another form control?
 
A

Allan Murphy

Altemir

You can use the eval function in the afterupdate event of the input field.

result_field=eval(me!input_field)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How use the GlueTo Method with 2D Shapes 0
VBA multiple list of values for variable 1
if a # then sum, if text leave null 2
Passing the value of ActiveControl to Unbound Text Box 1
Filtering Number Fields Using Wildcards 1
Append Query 2 4
How to create skip pattern in access 2013 form 0
How to Change criteria on a saved query using VBA 0

Top