If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Option Group Alternative
Using Access 2003
I've created a contact db. I want to be able to filter contacts in a list by the first letter of their last name. I can do this by creating an option group that has a toggle for each letter of the alphabet then setting up a VB script where CASE A etc selects the appropriate recordsource. This is all well and good, except that the graphic design of the toggle buttons is a dated look that does not match the rest of the DB. First, is there a way I can hide the toggle buttons like I do to command buttons? Second, if not, then I'm assuming the only way I can work around this is to create 26 command buttons assigning them each a letter of the alphabet - then give them an onClick to an unbound field which would keep their value - then assign the AfterUpdate property of each field to my case/recordsource VB to a listbox. Any suggestions? I've been shoveling all morning, so forgive me if I'm not as clear as I should be. TIA Aaron G Philadelphia, PA |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Option Group Label Issue | Jay | Using Forms | 8 | November 8th, 2005 01:51 PM |
Another option group problem | Emma | Using Forms | 1 | April 22nd, 2005 07:38 PM |
Is it possible to show both "Yes" and "No" answers from a "yes/no" checkbox? | Colin Foster | New Users | 28 | March 18th, 2005 02:19 PM |
Option Group to reports | [email protected] | Setting Up & Running Reports | 2 | January 17th, 2005 10:48 PM |
Unbound option group writing text values... | Davie P | Using Forms | 5 | August 12th, 2004 03:49 PM |