"Yes to All" button in MsgBox

[TheChairman]

Hello, I have a function that will delete records from a recordset based on selections from a listbox. The user can select multiple items from the listbox and the function will loop through the recordset deleting all the selected items. I have a prompt that pops up to confirm the deletion. The only problem is that if the user chooses to delete a large number of records, she will have to confirm each one. Is there any way that I can have a "Yes to All" button in the message box? It doesn't appear to exist in the button constants in Access 2007.

[pbaldy]

To my knowledge, no. You'll likely need to create a form to use in place of the message box, and open it with acDialog to make it work like a message box. I suppose an alternative would be to use a Yes/No/Cancel message box and word your message accordingly (Yes=delete all, No=Delete the one, Cancel = abort).

[SteveH2508]

There are demos available on custom message box captions available on the Internet. I use one which involves API calls, hooks etc.. (not for the faint-hearted!)

Try Googling custom message box captions or similar.