Using expressions in Msgbox

[hermanko]

Hi,

According to Access help, it is possible to display expressions in a
message box, as opposed to just text. I am not sure how to do this
properly, but I want a msgbox to display some text as well as a text
string that is referenced off another form.

The expression is:
=[Forms]![Step 1 Msg]![txt_step1msg]

When I insert only this into the message argument of the Msgbox macro
action, the message box displays the value correctly.

However, when i try to also add some typed text around it to make a
coherent sentence, the above expression just becomes a string and no
longer displays its referenced value.

How do i get around this?

Thanks!
Herman

 

[Steve Schapel]

Herman,

You forgot to mention what you tried. Doesn't this work?...

="Something " & [Forms]![Step 1 Msg]![txt_step1msg] & " something else."

 

[hermanko]

Yes, that does work. And i got it to work shortly after my post. Thanks
for the confirmation tho!
Herman