<div>
I have access 2003 handy, but it does sound similar to a piece we have here. &nbsp;The field that stores the attachment, if you go into design view of the table, what is the datatype? &nbsp;OLE Object?
</div>


<div>
nomoney,<br />
<br />
You cant print Directly from the attacment Field.<br />
<br />
You have to open the file.<br />
<br />
- RightClick the Attachment Field<br />
- Select &quot;Manage Attachment&quot;<br />
- Select the file<br />
- <br />

</div>


<div>
Opps!<br />
<br />
(Continued...)<br />
<br />
- Click Open<br />
<br />
<br />
Once the file is open, you can print it normally.
</div>


<div>
I'm playing with Access 2007 now. &nbsp;Attachement datatype does not appear to be created to do &quot;exactly&quot; as you want it. &nbsp;Jeff is correct. &nbsp;Also see <a href="http://www.cimaware.com/resources/article_135.html" rel="ugc">http://www.cimaware.com/resources/article_135.html</a>
</div>


<div>
To all,<br />
<br />
Funny thing is that Attachment Image files will display in a report.<br />
<br />
JeffCoachman
</div>


<div>
Thanks, I got in a &quot;let's use something new and cool&quot; loop and needed someone to get me out of it. I'm getting to old for this. : ) LOL
</div>


<div>
;-)<br />
<br />
There are some advantages to using the Attachment datatype, though<br />
The best being that now the files get compressed internally.<br />
<br />
Most developers still prefer to link the data rather than use OLE or Attachment datatypes.<br />
<br />
JeffCoachman
</div>


<div>
boaq2000-<br />
Jeff-<br />
I was trying to allow easy doc additions for the customer and unfortunately did testing with images and as you mentioned they worked, so duh, I didn't get around to testing the doc's until the customer was testing, so popping an ole field seemed a quick fix, but now per your suggestion I'm contemplating how to make a link easy for them to use. This is a small customer with only a few doc's that would ever be stored per client, but I shouldn't limit the customer.<br />
Thanks again 
</div>


<div>
OK,<br />
<br />
So where do we stand on this question?
</div>


<div>
Per your previous statement you cannot print an attachment in a report. <br />
Thanks
</div>


<div>
There are many techniques to linking the files.<br />
<br />
If you need any basic help, let me know
</div>


<div>
<div class="content wysiwyg-content">
I found one user who gave up and just decided to use ole instead of the attachment field, I would really like to print the document in a report instead of the Icon if anyone has any ideas. &nbsp;I have looked everywhere and can find no reference
</div>
</div>


I found one user who gave up and just decided to use ole instead of the attachment field, I would really like to print the document in a report instead of the Icon if anyone has any ideas.  I have looked everywhere and can find no reference

How Do I print a word doc from an attachment field in a report in Access 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.