Using expressions in Msgbox

  • Thread starter Thread starter hermanko
  • Start date Start date
H

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
 
Herman,

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

="Something " & [Forms]![Step 1 Msg]![txt_step1msg] & " something else."
 
Yes, that does work. And i got it to work shortly after my post. Thanks
for the confirmation tho!
Herman
 
Back
Top