David McAfee
DMcAfee at haascnc.com
Wed Apr 23 17:36:02 CDT 2003
Well in my example, My picture was located above a description like this:
PN 55-55555
------------------------
| |
| |
| |
| |
| |
------------------------
Description: blah blah blah
The picturebox was about 1 inch down
The description textbox was about 6 inches down.
So when I hid the picturebox by making it a height of 10 (.007"), I need to
shift the description up about 5 inches.
I think All I did was:
me.txtDescrip.top = (5 * 1440)
so you could do something like:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
On Err GoTo Detail_Format_Err
Dim PicLocation As String
PicLocation = Me!txtPixLocator & Me!txtPixName
If Nz(PicLocation,"")="" Then
Me.Image0.Height = 10
me.txtDescription.Top = 1.5 * 1440
Else
Me.Image0.Height = 5.5 * 1440
Me.txtDescription.Top = 6 * 1440
Me.Image0.Picture = PicLocation
End If
Detail_Format_Exit:
Exit Sub
Detail_Format_Err:
MsgBox Err.Number
Resume Detail_Format_Exit
End Sub
HTH
David McAfee
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow
Sent: Wednesday, April 23, 2003 2:31 PM
To: accessd at databaseadvisors.com
Subject: Fwd: RE: [AccessD] Pictures in reports
How do I move the text box to the correct location?
David McAfee <DMcAfee at haascnc.com> wrote:
From: David McAfee
To: "'accessd at databaseadvisors.com'"
Subject: RE: [AccessD] Pictures in reports
Date: Wed, 23 Apr 2003 14:28:01 -0700
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
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow
Sent: Wednesday, April 23, 2003 1:43 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Pictures in reports
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.'
Should I be setting it some other place?
David McAfee <DMcAfee at haascnc.com> wrote:
From: David McAfee
To: "'accessd at databaseadvisors.com'"
Subject: RE: [AccessD] Pictures in reports
Date: Wed, 23 Apr 2003 13:46:46 -0700
What about setting the picturebox height and width to zero (or .001") if
picture is not available?
David McAfee
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow
Sent: Wednesday, April 23, 2003 1:28 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Pictures in reports
An Image box in reports does not have this property.
"Wortz, Charles" <CWortz at tea.state.tx.us> wrote:
The field where you want to show a picture if there is one needs to have
its Can Shrink property set to True and the section that contains that
field also needs its Can Shrink property set to True.
Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us
-----Original Message-----
From: Dale Kalsow [mailto:dkalsow at yahoo.com]
Sent: Wednesday 2003 Apr 23 14:41
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Pictures in reports
If there is not picture I want the next record to be tight under the
previous record and if there is a picture then the picture should show
up between the records. Some records will have pictures and some will
not. The user can choose to tie a picture to his record if they want.
"Wortz, Ch! ! ! arles" wrote:
Subject: RE: [AccessD] Pictures in reports
Date: Wed, 23 Apr 2003 14:17:19 -0500
From: "Wortz, Charles"
To:
What do you want to do with the space the picture would have taken up?
Do you want to have two different layouts for your report, one for
records with pictures and one for records without pictures? If you do
want two different layouts, the easiest way is to have two different
reports. If that is not acceptable, then one report with two different
subreports and code to determine which subreport is appropriate to
populate and show.
If the above does not meet your needs, then please give more details of
what you want.
Charles Wortz
-----Original Message-----
From: Dale Kalsow [mailto:dkalsow at yahoo.com]
Sent: Wednesday 2003 Apr 23 13:58
To: accessd at databaseadvisors.com
Subject: [AccessD] Pictures in reports
I have a report that has multiple rec! or! ds! and each record may or may
not
have a picture assocated with it. If I do not have a picture for that
record I do not want to use the space that that picture would take up.
Does anyone know how to do this?
Thanks!
Dale
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_____
Do you Yahoo!?
The <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> New
Yahoo! Search - Faster. Easier. Bingo.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_____
Do you Yahoo!?
The <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> New
Yahoo! Search - Faster. Easier. Bingo.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_____
Do you Yahoo!?
The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com>
Yahoo! Search - Faster. Easier. Bingo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030423/c9b21302/attachment-0001.html>