Removing the Beep from one application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Access application runs a calculation through SQL and brings the value
back into Access. How do I get rid of the "BEEP" that arrives with the stgMsg
JUST for this Access application.

Else
strMsg = "Annualized Return (" & Me.cboComposite & ", " &
Me.cboStartDate & _
", " & Me.cboEndDate & "): " & Round(rst.Fields(0), 2) & "%." & _
(Chr(13) & Chr(10)) & (Chr(13) & Chr(10)) & "Click <OK> to continue."
strResponse = msgbox(strMsg, strStyle, strTitle)
 
Hi Sharon,

Does this messagebox have a different icon (Stop sign, question mark
....) from the others? If so, check the value of strStyle.

The second argument of MsgBox is a long integer, not a string, so the
fact that it's called strStyle here suggests that something may have got
confused.
 
Back
Top