Dale Kalsow
dkalsow at yahoo.com
Wed Apr 23 16:31:21 CDT 2003
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 recor! 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 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 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 Yahoo! Search - Faster. Easier. Bingo. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030423/671105ed/attachment-0001.html>