[AccessD] Hide and show image

Jim Hewson JHewson at karta.com
Fri Mar 24 16:12:22 CST 2006


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



More information about the AccessD mailing list