You can prevent a user from leaving a form field that has not been completed, though your bigger difficulty may be that you cannot force anyone to run the VBA necessary to do so.
The code required is reproduced at
http://www.gmayor.com/formfieldmacros.htm