Gustav Brock
Gustav at cactus.dk
Sat Mar 25 04:27:48 CST 2006
Hi David and Jim But the checkbox is only True or False: Me.Image5.Visible = Check6.Value /gustav >>> dajomigo at tpg.com.au 25-03-2006 00:02 >>> 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.