This is embarrassing and sorry for the long post. I've worked with MS Access since the mid 1990s and have literally created hundreds of programs. One thing I use to help debug code is quick and easy msgboxes, plus I use them behind forms for various things. I quit programming in 2009 and just recently went back into it with Office 365. I've found out that my quick and easy tool no longer works in this version, and works more like an input box than a msgbox. Am I right? Did it change? Have I failed to set some reference?
It used to be (down and dirty): msgbox="What a beautiful day" & OptionalParm, vbOkayonly, "MyTitle"
OR msgbox("What a beautiful day", vbOkayonly, "MyTitle")
OR (for debugging) msgbox "Code failed here"
but now I'm *required* to declare a variant and set it up this way:
dim msgTxt
msgtxt=msgbox("My cumbersome message")
If I don't set it up this way I get an error message stating that the right hand value must return a function call. This is more like an input box than a message box (of old).
Of course, the VBOkayOnly was selected from the intellisense dropdown
I find I cannot put the "vbOkayOnly" or any other thing after the initial message--it actually fails on the comma. Normally, I don't need to capture the return value of the vbOkayOnly, and I'm wondering if I'm just so rusty I've forgotten how to create a simple msgbox, or if it has changed someway. It's annoying not to be able to create a title without it failing or to do a simple box for code debugging.
Thanks for any help.