I have an Access 2000 database which consists of a datatable with several hundred records. Then I have a form which displays the records from the datatable with some nice borders and stuff. The database has three fields: "serial number," "name," and "PDF file." I only just recently added the "PDF file" field to the database. It is set as an OLE object in the datatable. And it is pulled onto the form as a "bound object frame."
My problem is, whenever I'm looking at the records (or a subset of the records) from the form, if there are embeded PDF files in any of the records showing on the rows, and I click on refresh, then the font on the records drops down to teeny-winy. After much experimentation, it turns out that this is intimately connected with the OLE object. I've set the format of the OLE object being pulled to the form to display as and icon. So I see a miniature Adobe Acrobat icon on that "PDF file" object on the form. I've set the "size mode" to Zoom (I've also tried Stretch). Whatever size that Access needs to zoom the icon down to make it fit in the control on the form, is what size the the font is on the rest of the records (intermittently).
I can consistently cause this behavior by clicking on RECORDS > REFRESH. The behavior goes away if there are no records showing on the form with PDF files embeded. The problem goes away if I hide the PDF file control on the form. The problem goes away if I set the "size mode" on the control to CLIP (both ZOOM and STRETCH) cause this misbehavior.
Anyone ever run accross this? Anyone know how I can get around this? Please no visual basic coding because I am totally illiterate in that.
Thanx in advance.