[AccessD] Hide and show image

David & Joanne Gould dajomigo at tpg.com.au
Fri Mar 24 16:08:38 CST 2006


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





More information about the AccessD mailing list