The use of on-exit macros, and userforms, is that these create the response document on the fly as the user fills out the questions (on-exit), or as an alternative to the formfields.

BTW in my opinion a properly designed userform is one of the better ways to go.

HOWEVER, we are not talking about a redesigned initial survey document. We are talking a process to deal with returned documents completely by the user. They have already checked the formfields. Therefore on-exits are not useful. They will never fire as YOU are not going to be tabbing in and out of the formfields. You only want to deal with the existing values.

So. You need a new template that will hold the code. It will create a new document and in THAT process start validating the existing formfield values. I have my hands full for the next few hours but I will hopefully be able to give you a sample chunk of code that may get you started shortly. Or, Charles may post something. He knows his stuff and has the experience to do so.

As you note, those links are VERY useful for future projects where you can design a better starting point, but they will not help with your after-the-fact current situation.