[AccessD] Hide and show image

Hi David
Either will work - 
That code (That Jim described) will work  on a report or on a form
Lets assume you have a form and You want to show the image based on the value in
the checkbox
Lets assume the wheelchair image is called imgWheelChair
Lets assume the checkbox is called chkHasWheelChairAccess

Put the image on the form and make it hidden (Visible = false)
Create a little function
Call it say...
ps_SetWheelChairImage and - Put it in the code behind the form up near the bit
that says Option Explicit
Copy and paste this

Private sub ps_SetWheelChairImage()

	If me.chkHasWheelChairAccess = -1 then ' Does have a tick in the box
		me.imgWheelChair.visible = true 'so show the image
	else ' there is no tick
		me.imgWheelChair.visible = false 'Don't show the image
	end if
End sub


Then in the ON_Current of the form have this

ps_SetWheelChairImage()

And in the OnClick of the textbox put...

ps_SetWheelChairImage()

That should sort out the form


For the report

Let's assume the image is in the detail section
Let's assume the Field in the table that holds the tick is Calle HasWCAccess
Let's assume it is in the record source of the report
Make sure the property sheet is visible (That's the one with the tabs called
Format, Data, Event, Other and All)
In design view there is a horizontal greay bar going all the way across the
screen called 'Detail'
Click it and then click on the Event tab of the property sheet
Then in the code behind the OnFormat have similar code

If me.HasWCAccess =-1 then
	me.chkHasWheelChairAccess.visible = true
Else
	me.chkHasWheelChairAccess.visible = False
End if


Phew sounds like a lot
But is simple

Lemme know off list if you're still aving trouble and I'll knock up a demo

Hope this helps

See ya



Darren
------------------------------
T: 0424 696 433
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David & Joanne Gould
Sent: Saturday, 25 March 2006 9:09 AM
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