<div>
I tried this and while the resizing works the image appears for all records despite the fact that the PathToImage is blank for many of them:<br />
<br />
&nbsp; &nbsp;Dim FullPath As String<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; If IsNull(Me.PathToImage) Or Me.PathToImage = &quot;&quot;&nbsp;Then GoTo ExitHere<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; FullPath = Me.PathToImage<br />
<br />
&nbsp; &nbsp; If Dir([FullPath]) &lt;&gt;&nbsp;Empty Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.[Image27].Visible = True<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.[Image27].Picture = FullPath<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.[Image27].Height = 1800<br />
&nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.[Image27].Visible = False<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.[Image27].Height = 0<br />
&nbsp; &nbsp; End If<br />
&nbsp; &nbsp; FullPath = &quot;&quot;
</div>


I tried this and while the resizing works the image appears for all records despite the fact that the PathToImage is blank for many of them:

   Dim FullPath As String
   
    If IsNull(Me.PathToImage) Or Me.PathToImage = "" Then GoTo ExitHere
   
    FullPath = Me.PathToImage

    If Dir([FullPath]) <> Empty Then
        Me.[Image27].Visible = True
        Me.[Image27].Picture = FullPath
        Me.[Image27].Height = 1800
    Else
        Me.[Image27].Visible = False
        Me.[Image27].Height = 0
    End If
    FullPath = ""

<div>
<div class="content wysiwyg-content">
I have a report where some records have links to images and others do no. I would like to automatically resize an Image Control to eliminate white space. I can't seem to find anything. Any ideas?
</div>
</div>


I have a report where some records have links to images and others do no. I would like to automatically resize an Image Control to eliminate white space. I can't seem to find anything. Any ideas?

Microsoft Access Report (Image Control Issue)

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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.