[AccessD] Images on Continuous Forms or Reports

HI Dan
Haven't done this but try something like this
Have the image control sizes virtually invisible 
eg Width = 1 Height =1
Then for each row that has the image visible try something like
(Testing only for a value in the phone number field (at Table Level not control level) of a contacts database)

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.PhoneNumber) Then
    Me.Image0.Visible = False
    Me.Image0.Height = 1
    Me.Image0.Width = 1
Else
    Me.Image0.Visible = True
    Me.Image0.Height = 200
    Me.Image0.Width = 200
End If

End Sub

Hope this helps and works

Darren





----- Original Message ----- 
From: "Dan Waters" <dwaters at usinternet.com>
To: "Database Advisors" <accessd at databaseadvisors.com>
Sent: Thursday, March 11, 2004 9:36 AM
Subject: [AccessD] Images on Continuous Forms or Reports


> Hello to All!
> 
>  
> 
> I have a need to display an image on a row in a continuous report.  However,
> some rows will have an image and some won't.  I know how to make that work.
> 
>  
> 
> What I would like to be able to do is have the detail section of the report
> (or form) grow or shrink in accordance with the size of the image or whether
> or not the image exists.  When I started this I assumed that the image
> control would have grow and shrink properties, but NO they don't!
> 
>  
> 
> I also looked at bound and unbound object frames, but they also don't have
> grow and shrink properties.
> 
>  
> 
> Can anyone point me in the right direction?
> 
>  
> 
> Thanks!
> 
> Dan Waters
> 
>  
> 
>  
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com