Receiving Access Violation Error on Word Macro

[John Crews]

Receiving this error on a Word Macro:

WINWORD.EXE: 0xC0000005: Access violation reading location 0x00000003.



Can anyone help.

 

[Doug Robbins - Word MVP]

What Word macro?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[John Crews]

Actually I figured out that the access violation occurred when I ran a
function that called the Cdbl() to convert numbers to double. It would only
do this when using the mouse to advance through the form fields. If I
tabbed through fields the error would not occur. Weird.



The solution for me was to remove all VBA code projects and use the
'Calculate on Exit' with expressions in the appropriate form fields. Doing
this actually improved performance. This is what I should of done in the
beginning.



Thanks