PDF File content display on Access 2013 form

[saleemsadique]

I have an table with attachment field in which PDF files are attached.


I need Access 2013 form to display PDF file content instead of PDF icon
While record changed should display PDF content for each record navigated

[Xipooo]

Use a "WebBrowser" control.

[saleemsadique]

how can I assign data from attached field to web browser control

[Xipooo]

how can I assign data from attached field to web browser control

You can either set it in the Data tab of the WebBrowser object properties and clicking on the ellipsis next to "Control Source", or you can set it programmatically through VBA code.

Private Sub Form_Load()
     Me.WebBrowserName.ControlSource = "c:\root\subfolder\filename.pdf"
     Me.Refresh
End Sub

[saleemsadique]

I wont be pulling pdf files from drive. I have already attached files in a table field. when I run my form my jpg file shows the pictures where as pdf file contents not displayed it show PDF icon

[June7]

Are you aware Access has a 2GB size limit? Files embedded in attachment field can use up that limit fast.

[Xipooo]

I wont be pulling pdf files from drive. I have already attached files in a table field. when I run my form my jpg file shows the pictures where as pdf file contents not displayed it show PDF icon

Access doesn't natively support the displaying of PDF files that's why it must be displayed in the web browser. You can export the Attached file as a PDF file then display it in the web browser but that would require some bit of coding and much more information about your database.

[saleemsadique]

Thanks to all, I did the same...saved attachments to a folder and pulled from there....