Jim Hewson
JHewson at karta.com
Fri Mar 24 15:42:59 CST 2006
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