Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 September 4th, 2003, 01:32 PM
Registered User
 
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to set checked listbox in access application.

Is anybody know how to set a checked listbox in access 97 application?
In VB, listbox has two styles, one is vbListBoxStandard, other is vbListboxcheckedbox. Is it possible we can do the something in access 97 application? Thanks.
 
Old September 4th, 2003, 10:46 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Unfortunately no. But you can emulate VB6's checked style as follows:

1. Place a textbox in the detail section of a form.
2. Place a checkbox immediately to the right of the textbox.
3. Set the forms Default View to Continuos Forms.
4. Set the forms record source to a table of lookup values.
5. Use the check boxe's click event to communicate with controls on
   the parent form using Me.Parent syntax.

HTH,

Bob

 
Old September 5th, 2003, 09:52 AM
Registered User
 
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by Skyblue
 Is anybody know how to set a checked listbox in access 97 application?
In VB, listbox has two styles, one is vbListBoxStandard, other is vbListboxcheckedbox. Is it possible we can do the something in access 97 application? Thanks.
Thanks, I will try it.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkboxes undefined when not checked MS Access Morn ASP.NET 2.0 Basics 29 February 19th, 2007 04:58 PM
Checkboxes undefined when not checked MS Access Morn Classic ASP Basics 0 February 15th, 2007 05:07 PM
Set Listbox Selected property DaDeViL VB How-To 7 October 4th, 2006 04:04 PM
Set Default selection in ListBox nmreid Classic ASP Basics 0 January 20th, 2006 04:49 PM





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