Help! How to convert a math function (string) into a number

message from JM on 01 Jun 2004
Hi,

str = "exp(5)+sqr(4)"

How to convert that string into its numeric value???

I have tried:
dbl = val (str)
and
dbl = CDbl(str)
but does not works.

HELP!!
Thanks,

Jaime
 
John Vinson replied to JM on 01 Jun 2004
Try

dbl = Eval(str)

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
 

Archived message: Help! How to convert a math function (string) into a number (Microsoft Access Error Message)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.