Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 15th, 2004, 07:21 AM
Registered User
 
Join Date: Nov 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default MS Access Forms Labels

Is there any way of displaying, within a button or label on a MS Access form, both a picture and text?
i.e. displaying an icon file (tick or other image) and the word "OK" or other text.

 
Old November 15th, 2004, 09:47 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The easiest(and possibly only) way to do this is to include the text in your graphic.


Brian Skelton
Braxis Computer Services Ltd.
 
Old November 15th, 2004, 10:31 AM
Registered User
 
Join Date: Nov 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Brian, your solution did occur to me, but, I wondered whether it could be achived by using the ActiveX control MS Forms 2 Label?
For the moment I'll hang fire with your solution. I find it strange though, that what I'm after, can be done in MS Excel forms using the label contol?

 
Old November 15th, 2004, 11:39 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It doesn't look as if the MS Forms controls have a picture property when used in Access...


Brian Skelton
Braxis Computer Services Ltd.
 
Old November 15th, 2004, 12:29 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

One way to get around it is to place a label with its background property set to transparent over the button and make it the same size as the button. Make sure you format the label as "Bring to Front". Then place the ON CLICK procedure on the label, not the button. Not exactly elegant, but it works.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB mohankumar0709 SQL Server 2005 3 March 23rd, 2007 12:48 AM
Labels in Access taraj Access 2 May 16th, 2005 01:35 PM
how do I store forms in an MS Access table? neuralsea Access VBA 1 August 14th, 2004 04:34 PM
Printing address labels ASP/Access bjtindle Access ASP 1 September 23rd, 2003 11:57 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.