Need Msgbox to close after especific time

[Secue]

Hi:



I'm developing an application to compare information that use will enter on two text boxes (field son a table) I will compare both informations, if informtion is the same I need to notify user it is OK, I'm thinking on a msgbox, but I need no interaction from user to close the msgbox and go to the next record and enter the next pair of information. How can I set msgbox to display a message but to close it automatically after a few seconds?

Is there a way to do it?

Thank you.

[June7]

Never seen it and would have though no, so I Binged: VBA MsgBox timeout.

http://social.msdn.microsoft.com/For...t?forum=isvvba

That's annoying - it works in Excel VBA but not Access VBA.

[Missinglinq]

I think you'd need to use small Popup Form displaying your message, open it and then use the Form's Timer Event to then close it after N seconds. Or you could use a Label, controlling its Visible Property, making it Visible, as appropriate, then once again using the Form's Timer Event to make it invisible, again.

Linq ;0)>

[June7]

Yes, looks like the only way is with a form, not the intrinsic MsgBox.

Unless I am doing something wrong in the Access VBA code. I use the same code in Excel VBA and it worked.