Ive got an OLE control on my report that contains an image.
If no image is present, I resize it to very small, and when an image is presnent I resize the control to an appropriate size.
This works fine in print preview - when no image is present, no space is taken up on the report.
But when I print, regardless of whether an image is present or not, it always takes up the space as if it was there.
This is the simple code I have been using:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull([Image]) Then
OLEImage.Width = 1
OLEImage.Height = 1
Else
OLEImage.Width = 4000
OLEImage.Height = 2500
End If
End Sub
Any Ideas?
If no image is present, I resize it to very small, and when an image is presnent I resize the control to an appropriate size.
This works fine in print preview - when no image is present, no space is taken up on the report.
But when I print, regardless of whether an image is present or not, it always takes up the space as if it was there.
This is the simple code I have been using:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull([Image]) Then
OLEImage.Width = 1
OLEImage.Height = 1
Else
OLEImage.Width = 4000
OLEImage.Height = 2500
End If
End Sub
Any Ideas?