CAN SHRINK

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

Can anyone tell me why the CAN SHRINK does not work when applied to OLE
linked documents. If there is another way to suppress blank OLE fields would
you please advise

thanks in advance
 
Here is a previous post of mine on this subject:

From: Stephen Lebans
([email protected])
Subject: Re: 'Can shrink' question
View this article only
Newsgroups: microsoft.public.access.reports
Date: 2004-04-14 07:44:30 PST


David it works here with A2K or higher.

Here is the code copied from your report:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

' Set the OLE Frame control's Visible prop to NO if empty.
If IsNull(Me.Photo5.Value) Then
Me.Photo5.Visible = False
Else
Me.Photo5.Visible = True
End If

Me.Section(acDetail).Height = 0

End Sub



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top