<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff size=2>Well
in my example, My picture was located above a description like
this:</FONT></SPAN></DIV>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff size=2>PN
55-55555</FONT></SPAN></DIV>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff
size=2>------------------------</FONT></SPAN></DIV>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff
size=2>|
|</FONT></SPAN></DIV><SPAN class=728121022-23042003>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff
size=2>|
|</FONT></SPAN></DIV>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff
size=2>|
|</FONT></SPAN></DIV>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff
size=2>|
|</FONT></SPAN></DIV>
<DIV><SPAN class=728121022-23042003><FONT face=Arial color=#0000ff
size=2>|
|</FONT></SPAN></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=728121022-23042003>------------------------</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=728121022-23042003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><SPAN class=728121022-23042003></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN class=728121022-23042003>Description: blah blah
blah</SPAN>
<BR></FONT></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>The picturebox was about 1 inch
down</FONT></SPAN></DIV></FONT></FONT></FONT></FONT>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>The description textbox was about 6 inches down.
</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>So when I hid the picturebox by making it a height of 10
(.007"), I need to shift the description up about 5 inches.
</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>I think All I did was:
</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>me.txtDescrip.top = (5 *
1440)</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>so you could do something
like:</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>On Err GoTo
Detail_Format_Err<BR></FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>Dim PicLocation As
String</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>PicLocation = Me!txtPixLocator &
Me!txtPixName<BR><BR> If Nz(PicLocation,"")=""
Then</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2> Me.Image0.Height
= 10<BR> me.txtDescription.Top = 1.5 *
1440</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>
Else</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2> <SPAN
class=728121022-23042003><FONT face=Arial color=#0000ff size=2>Me.Image0.Height
= 5.5 * 1440<BR>
Me.txtDescription.Top = 6 *
1440</FONT></SPAN> </FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>
Me.Image0.Picture = PicLocation<BR> End
If<BR></FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>Detail_Format_Exit:<BR> Exit
Sub</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff
size=2>Detail_Format_Err:<BR> MsgBox
Err.Number<BR> Resume
Detail_Format_Exit<BR> <BR>End
Sub<BR></FONT></SPAN></DIV></FONT></FONT></FONT></FONT>
<DIV><FONT><FONT><FONT face=Arial><FONT color=#0000ff><FONT
size=2></FONT></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>HTH</FONT></SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><FONT><FONT><SPAN class=728121022-23042003><FONT face=Arial
color=#0000ff size=2>David
McAfee</FONT></SPAN></DIV></FONT></FONT></FONT></FONT></SPAN>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Dale
Kalsow<BR><B>Sent:</B> Wednesday, April 23, 2003 2:31 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Fwd: RE: [AccessD] Pictures in
reports<BR><BR></FONT></DIV>
<DIV>How do I move the text box to the correct location?<BR><BR><B><I>David
McAfee <DMcAfee@haascnc.com></I></B> wrote:
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">From:
David McAfee <DMCAFEE@HAASCNC.COM><BR>To: "'accessd@databaseadvisors.com'"
<ACCESSD@DATABASEADVISORS.COM><BR>Subject: RE: [AccessD] Pictures in
reports<BR>Date: Wed, 23 Apr 2003 14:28:01 -0700<BR><BR>
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<DIV><SPAN class=764111721-23042003><FONT face=Arial color=#0000ff
size=2>IIRC, Me.Image0.Height = 10 DOES work (for me at least) in A97, but I
had to move up any text box that was under it and move them back down if the
picture exists (as well as making the picture box 5" tall again:
Me.Image0.Height = (5 * 1440)). I believe I had to do this in the
Detail_Format not Detail_Print</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Dale
Kalsow<BR><B>Sent:</B> Wednesday, April 23, 2003 1:43 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Pictures in
reports<BR><BR></FONT></DIV>
<DIV>
<DIV>I tried that by setting it in the Detail_Print section. I get
the error 'Can not set the Height Property in print preview or after
printing has started.'</DIV>
<DIV><BR>Should I be setting it some other place?<BR><B><I>David
McAfee <DMcAfee@haascnc.com></I></B> wrote:</DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">From:
David McAfee <DMCAFEE@HAASCNC.COM><BR>To:
"'accessd@databaseadvisors.com'"
<ACCESSD@DATABASEADVISORS.COM><BR>Subject: RE: [AccessD] Pictures in
reports<BR>Date: Wed, 23 Apr 2003 13:46:46 -0700<BR><BR>
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<DIV><SPAN class=423393720-23042003><FONT face=Arial color=#0000ff
size=2>What about setting the picturebox height and width to zero (or
.001") if picture is not available?</FONT></SPAN></DIV>
<DIV><SPAN class=423393720-23042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=423393720-23042003><FONT face=Arial color=#0000ff
size=2>David McAfee</FONT></SPAN></DIV>
<DIV><SPAN class=423393720-23042003></SPAN><FONT face=Tahoma><FONT
face=Arial color=#0000ff size=2></FONT><BR><FONT size=2><SPAN
class=423393720-23042003><FONT face=Arial
color=#0000ff> </FONT></SPAN>-----Original
Message-----<BR><B>From:</B> accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Dale
Kalsow<BR><B>Sent:</B> Wednesday, April 23, 2003 1:28 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Pictures
in reports<BR><BR></FONT></DIV></FONT>
<BLOCKQUOTE>
<DIV>An Image box in reports does not have this property.</DIV>
<DIV><BR><BR><B><I>"Wortz, Charles"
<CWortz@tea.state.tx.us></I></B> wrote:</DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">The
field where you want to show a picture if there is one needs to
have<BR>its Can Shrink property set to True and the section that
contains that<BR>field also needs its Can Shrink property set to
True.<BR><BR><BR>Charles Wortz <BR>Software Development Division
<BR>Texas Education Agency <BR>1701 N. Congress Ave <BR>Austin, TX
78701-1494 <BR>512-463-9493 <BR>CWortz@tea.state.tx.us
<BR>-----Original Message-----<BR>From: Dale Kalsow
[mailto:dkalsow@yahoo.com] <BR>Sent: Wednesday 2003 Apr 23
14:41<BR>To: accessd@databaseadvisors.com<BR>Subject: RE: [AccessD]
Pictures in reports<BR><BR><BR>If there is not picture I want the
next record to be tight under the<BR>previous record and if there is
a picture then the picture should show<BR>up between the records.
Some records will have pictures and some will<BR>not. The user can
choose to tie a picture to his record if they want.<BR><BR>"Wortz,
Ch! ! ! arles" <CWORTZ@TEA.STATE.TX.US>wrote: <BR>Subject: RE:
[AccessD] Pictures in reports<BR>Date: Wed, 23 Apr 2003 14:17:19
-0500<BR>From: "Wortz, Charles" <BR>To: <BR><BR><BR>What do you want
to do with the space the picture would have taken up?<BR>Do you want
to have two different layouts for your report, one for<BR>records
with pictures and one for records without pictures? If you
do<BR>want two different layouts, the easiest way is to have two
different<BR>reports. If that is not acceptable, then one report
with two different<BR>subreports and code to determine which
subreport is appropriate to<BR>populate and show.<BR><BR>If the
above does not meet your needs, then please give more details
of<BR>what you want.<BR><BR>Charles Wortz <BR>-----Original
Message-----<BR>From: Dale Kalsow [mailto:dkalsow@yahoo.com]
<BR>Sent: Wednesday 2003 Apr 23 13:58<BR>To:
accessd@databaseadvisors.com<BR>Subject: [AccessD] Pictures in
reports<BR><BR><BR>I have a report that has multiple rec! or! ds!
and each record may or may not<BR>have a picture assocated with it.
If I do not have a picture for that<BR>record I do not want to use
the space that that picture would take up.<BR>Does anyone know how
to do
this?<BR><BR>Thanks!<BR><BR>Dale<BR>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com</BLOCKQUOTE>
<P><BR>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">The
New Yahoo! Search</A> - Faster. Easier.
Bingo.</BLOCKQUOTE>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></DIV>
<P><BR>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">The
New Yahoo! Search</A> - Faster. Easier.
Bingo.</BLOCKQUOTE>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></DIV>
<P><BR>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">The New
Yahoo! Search</A> - Faster. Easier. Bingo.</BLOCKQUOTE></BODY></HTML>