[AccessD] Hide and show image

Thanks Jim

Works a treat

David

At 09:12 AM 25/03/2006, you wrote:
>I was talking about a form.
>On a report, you can use the same procedure except put the image control 
>in the detail section and use the if statement in Format event.
>The image will show or not show as needed.
>
>Jim
>jhewson at karta.com
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com 
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David & Joanne Gould
>Sent: Friday, March 24, 2006 4:09 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Hide and show image
>
>Jim
>
>Thanks for you quick response.
>
>Are you talking about the report or the form?
>
>If the report, where do I put code as I couldn't find anywhere for it?
>
>If the form, how do I store the image into the table?
>
>TIA
>
>David
>
>At 08:42 AM 25/03/2006, you wrote:
> >David,
> >WI would use the image control with the picture of the wheelchair
> >(bmp).  The image control can be scaled to the size you need. Just make
> >sure the Size Mode is set to Zoom.  Then use code to hide or unhide the
> >image control as needed using the docmd visible command.
> >For example:
> >On the after update event of the checkbox use a simple if statement.
> >
> >         If Check6 = 0 Then
> >                 Me.Image5.Visible = False
> >         Else
> >                 Me.Image5.Visible = True
> >         End If
> >
> >Then when it's checked the Wheelchair will show, unchecked the image is
> >not shown.
> >
> >HTH
> >
> >Jim
> >jhewson at karta.com
> >
> >-----Original Message-----
> >From: accessd-bounces at databaseadvisors.com
> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David & 
> Joanne Gould
> >Sent: Friday, March 24, 2006 3:29 PM
> >To: Access Developers discussion and problem solving
> >Subject: [AccessD] Hide and show image
> >
> >
> >A database has a check box in its table/form for whether a certain location
> >has wheelchair access or not. If it does have wheelchair access, then on a
> >listing report, the usual wheelchair symbol is to be displayed next to its
> >address. If it doesn't have access, a symbol is not displayed.
> >
> >1. Can this be done and if so how? I couldn't find anywhere to set the code.
> >2. The only option I could think of was to actually store the image in the
> >table with the user having to manually insert the image into the field. Can
> >the insertion be automated based on their choice at the checkbox?
> >
> >TIA
> >
> >David
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com