David & Joanne Gould
dajomigo at tpg.com.au
Fri Mar 24 17:03:38 CST 2006
Thanks William I will look into your suggestion. It's something I haven't used before. This time I have used Jim's solution. Thanks again David At 09:13 AM 25/03/2006, you wrote: >...I'd consider using the Unicode font wheelchair symbol U+267F instead of >an image graphic ...if they don't have a suitable font already installed you >can install it with your distribution ...you can then use an IIF to >determine whether it gets displayed ...should be much quicker and simpler >than an image. > >William > >----- Original Message ----- >From: "Jim Hewson" <JHewson at karta.com> >To: "Access Developers discussion and problem solving" ><accessd at databaseadvisors.com> >Sent: Friday, March 24, 2006 4:42 PM >Subject: Re: [AccessD] Hide and show image > > > > 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