Msgbox dialog problem

  • Thread starter Thread starter Special Access
  • Start date Start date
S

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
 
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
 
Sorry, missed out a " should be:
MsgBox "Sorry" & vbCrLf & vbCrLf & "No Results from search" & vbCrLf &
vbCrLf & "Please try again"

- Steve Schapel, Microsoft Access MVP
 
Sorry, missed out a " should be:
MsgBox "Sorry" & vbCrLf & vbCrLf & "No Results from search" & vbCrLf &
vbCrLf & "Please try again"

- Steve Schapel, Microsoft Access MVP
Click to expand...


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

Thanks for the info!
 
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!!
Click to expand...

- Steve Schapel, Microsoft Access MVP
 
Back
Top