Visit our new web pages

We have launched a new extended set of web pages at www.alvechurchdata.co.uk. These old pages will stay on the server because people still have links to them but they will not be updated.

The new version of this page is at www.alvechurchdata.co.uk/hints-and-tips/accconfirm.html.

Wrapping the call to MsgBox

The MsgBox() function lets you display a standard Windows dialog to get a Yes/No answer from the user. The dialog is reliable and familiar but the call to this function can be a bit verbose:

This call then gives you a return value of 6 or 7 so you need to write further code to determine whether the user said 'Yes' or 'No'.

You can make life a lot easier by writing a function to wrap the MsgBox call. We use a function named "Confirm" which takes the text and title as parameters and converts the numeric return from MsgeBox into True or False.

The body of the function is very simple:

The code to use this function is much easier to write than the call to MsgBox because you can embed it into an If Confirm("Are you sure", "Delete record") Then...

An additional bonus in our work is that we have no longer have to remember the different calling conventions and the different names for the constants in the FoxPro and Access messageboxes - we have written a "Confirm" function in both languages.