In MS Access how can I stop the user from losing focus on a text box if a condition is not met. For example if the box isnull I want a message box to appear and the user still be in the text box. I tried the lose focus event but I could only get the message box to appear, I didn't know how to stop the move to the next box. I know in the before update event there is cancel which allows this. I tried having Cancel As Integer as an argument but Access gave me an error.
Start Free Trial
