Word 97 Formfield exit macro

[sdraper]

I am building a form in Word 97. I have added a field named "txtSSnum". I have also written a macro called FormatSSNum that is in a module in the same document as the form field. My intention was to set it as the exit macro for the formfield I created above. However, only macros in Normal are appearing in the dropdown list of exit macros. I thought I would be slick and assign the exit macro in code but, alas, I got an error that the item was not part of the collection. If I move the macro to Normal all is well but that isn't what I want since I intend to distribute the document. anyone have any suggestions??
Thanks in advance,

Sam

 

[Dreamboat]

What does it do?
Format as SSN?
Why not just put that as the format of the formfield?

000-00-0000, I do believe.

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[sdraper]

Yes formats but also hits a database as well. Thanks for your fast response!

Sam

 

[Dreamboat]

Sure.
So...
Hm...
You're sure your macro RESIDES in ThisDocument?
Where do you have it stored?
Is it a regular SUB and not Private?

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[sdraper]

I have tried it in this document and also in a module in this document.
it is declared as
sub FormatSSNum()
'my killer VBA code heheheh
end sub



Sam

 

[Dreamboat]

I'll test it if you want. Anne@TheOfficeExperts.com

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[sdraper]

I appreciate the offer but I work for Illinois Secretary of State and I can't send you the doc without almost literally an act of congress. From my description so you think it should work? If so I will dig some more.

Sam

 

[Dreamboat]

Save the doc as something else.
Delete all unnecessary.
Include the macro.


Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[Dreamboat]

Oh. Yes. We SHOULD be able to get it to work.

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[sdraper]

As usual when I really start to get into something, a user or my manager calls with some other thing to work on. It will probably be monday before I get to do anything else with this. thanks for all of your input. I will post more hopefully monday.
Have a rockin weekend!



Sam