Report issue with Images

[Arvin]

Hello,

I am trying to create a report that will display images, the issue i'm having is with empty whites spaces....

when I run the report ..... it will display images were it needs to but when there isn't a image to be displayed ... I get a blank white space .... I have no idea how to resolve this issue .....

Please advise and thank you in advance,

Arvin

 

[Simon_MT]

I think you will find that the ImageControl does resize.

However, I would be inclined to dispense with the Image and put the information into a table and use a SubReport. The information could then be analysed.

Simon

 

[scalextric59]

here it is:

If IsNull(Me.Image) Or Trim(Me.Image) = "" Then
Me.Image.Visible = False
Me.Image.Height = 0.01 * 1440
Me.Detail.Height = 0.75 * 1440
Else
Me.Image.Visible = True
Me.Image.Height = 2 * 1440
Me.Detail.Height = 2.75 * 1440
End If

Note: * 1440 to convert to twips

 

[DCrake]

Resizing the image control if null is only half of the issue. You still need to resize the detail section as space has been provided for the image. Take the image away and the size is still the same.

 

[scalextric59]

The code provided before accounts for that (me.detail.Height)

 

[DCrake]

Ok but whre in your report are you handling this code$?

 

[scalextric59]

The code goes under the Detail_Format event. Forgot to mention that.