See the result of text in text box

[MyTech]

I have 2 Fields:
1. [Message]
2. [Result]

I want to see in [Result] the result of the text in [Message].

Text in [Message] is "Application.Printer.DeviceName" (w/o Quotes).

Double Click VBA for [Message] is:

Private Sub Message_DblClick(Cancel As Integer)
Result = [Message]
End Sub​

I expect now to see in [Result] the name of my default printer.
but no, I just get there the text as it's in the text box "Application.Printer.DeviceName".


Any help please?

 

[boblarson]

1. Result is an Access Reserved Word.

2. You have to use Eval with it:

Eval([Message])

 

[MyTech]

here you are again Bob,

Thank you thiiiiiiiiis much.

 

[smig]

aviod names that might be reserved words

 

[MyTech]

You're right Smig, I'll change them.