A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Option Group Alternative



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old December 9th, 2005, 04:28 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.