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