CAN SHRINK

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
 
S

Stephen Lebans

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can shrink not responding 3
Can Shrink an Image Field? 1
OLE object, can grow, can shrink 1
Hiding bound OLE fields when there's nothing in them 1
VB6 Component Issue with TDBGRID 0
compressing rows in report details 2
can shrink, can grow ole field 2
Ole field can shrink, can grow properities 1

Top