If one types the following in a cell in Excel

=7+4

the result 11 is stored in the cell.

Is it possible to get an Access textbox to emulate this functionality. I'm sure I've read about doing it in the past but just can't remember where. Many thanks.

Clive Astley

__________________
Clive Astley

There isn't for a cell in a table in the same manner, but in the AfterUpdate event for a cell you call the Eval function.

Example: In a textbox, I enter 11/4 and if I have an after update event on the form to convert to a decimal such as

TxtNum = Replace(TxtNum, " ", "+")
TxtNum = Eval(TxtNum)

The result would be 2.75

There would be additional code to trap any errors and make sure the value is numeric, but read up on the Eval function in online help.

HTH,

Beth

Many thanks Beth

Clive Astley