Msgbox dialog problem

[Special Access]

I have a message box that comes up if the search results are null.
With Access 97, it worked fine. With Access 2000 SP3, (and even prior
to updating) I get this in the message box:

Sorry@No Results from search@Please try again

 

[Sandra Daigle]

There is a difference in the way A2000+ handles the msgbox function so it no
longer recognizes the formatting syntax using the '@'. For more information
and a workaround function see:

http://www.trigeminal.com/usenet/usenet015.asp?1033

 

[Steve Schapel]

Special,

Your original code to write the MsgBox message used the @ action
separator which is no longer supported in later versions. If you
define the MsgBox in code, try this...
MsgBox "Sorry" & vbCrLf & vbCrLf & "No Results from search & vbCrLf &
vbCrLf & "Please try again"

- Steve Schapel, Microsoft Access MVP

 

[Steve Schapel]

Sorry, missed out a " should be:
MsgBox "Sorry" & vbCrLf & vbCrLf & "No Results from search" & vbCrLf &
vbCrLf & "Please try again"

- Steve Schapel, Microsoft Access MVP

 

[Special Access]

There is a difference in the way A2000+ handles the msgbox function so it no
longer recognizes the formatting syntax using the '@'. For more information
and a workaround function see:

http://www.trigeminal.com/usenet/usenet015.asp?1033

It had me going because the "help" files still list this as a viable
option. Gotta love MS sometimes <sigh>

Thanks!!

 

[Special Access]

Sorry, missed out a " should be:
MsgBox "Sorry" & vbCrLf & vbCrLf & "No Results from search" & vbCrLf &
vbCrLf & "Please try again"

- Steve Schapel, Microsoft Access MVP

Figures... just figure something out and MS goes and changes it <grin>

Thanks for the info!

 

[Steve Schapel]

Yes, the Access2000 Help is wrong on this topic

- Steve Schapel, Microsoft Access MVP

It had me going because the "help" files still list this as a viable
option. Gotta love MS sometimes <sigh>

Thanks!!

- Steve Schapel, Microsoft Access MVP