Access 2003 report. Based on an OLE Word Document and then 15 fields that show up overlayed on the document when viewed or printed as an Access report. Standard use of OLE Word in Access.
This OLE Word doc is like this ______________ and this ______________ where the underline is part of the document and the Access bound fields are superimposed over the document. The Text Boxes are transparent, and the Word Document's underline shows under the field on the viewed or printed report. Again, standard stuff.
I have ONE WORD I need to change on the entire report. I open up the report, I go into design view, I double click to bring up the word document that is embedded, and I modify the single word. When I return to view the report, every underline that is part of the background document is gone. In the whole report.
Immediately I think maybe something shifted down so now all my Access fields are over all the word underline areas. So I mess around a bit and then I just decide to remove all the fields all together to see if my underlines lines come back . . . and they are still all gone!
Now I know of different ways I can fix it by either getting rid of the OLE or maybe setting up the OLE all over again. I can also have the text boxes themselves show the line and not have it built into the background document. But I just wanted to know what causes it, and how cam I avoid it???
I have taken over databases where this OLE is used extensively from back in the transitional days where forms and reports to were imported into Access. Some places I have scrapped the OLE and designed it all in Access, but it's a long uphill battle and I would like to control the variables just a bit better. I hope my plight makes sense.
Start Free Trial
