eval() ignores everything after '!" or '.' in argument

[visions]

Hello,I tried using eval() like this:

eval("AB16_" & "Total.value")

But, Access ignores the dot and everything after it so that my statement in effect becomes:

eval("AB16_Total")

I did not expect this and can't find documentation regarding this. Further, if I replace the dot with a "!" I get the same result.



Thanks for the help.

[June7]

I don't think that is correct use of Eval().

Eval() will take a string of characters like: "5 ^ 3 / 4" and do the math.

If you want to concatenate the content of Total to the string "AB16_", then try:

"AB16_" & [Total]

Where are you doing this calc - in query, in textbox, in VBA?

What are you really trying to accomplish?

[Missinglinq]

Assuming that Total, or AB16_Total is a Textbox, on your Form, it doesn't really matter. Since .Value is the Default Property of a Textbox, in VBA

AB16_Total.Value

and

AB16_Total

means the exact same thing! But like June7, I not sure that this is a valid use of Eval()! What would typical data in this Control look like?

Linq ;0)>

[visions]

Assuming that Total, or AB16_Total is a Textbox, on your Form, it doesn't really matter. Since .Value is the Default Property of a Textbox, in VBA

AB16_Total.Value

and

AB16_Total

means the exact same thing! But like June7, I not sure that this is a valid use of Eval()! What would typical data in this Control look like?

Linq ;0)>

Thanks June7 and Missinglinq.
That the default property of a control is value takes care of my question