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
  #1  
Old December 9th, 2005, 05: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
  #2  
Old December 10th, 2005, 12:50 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Option Group Alternative

When you create your option group, you can choose to use toggle buttons
instead of radio buttons.

"Aaron G" wrote in message
news
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



  #3  
Old December 10th, 2005, 12:55 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Option Group Alternative

Try using another aproach - ComboBox with Autoexpand property to Yes.

"Aaron G" wrote:

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

  #4  
Old December 11th, 2005, 02:07 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Option Group Alternative


"KARL DEWEY" wrote in message
...
Try using another aproach - ComboBox with Autoexpand property to Yes.


Or even better a list box resized to show the 26 values, in simple selection
mode, with an afterupdate event to execute the actions you will need to
change the selection...

Or, 26 cmdButtons, but that is going to be ugly...

Francois


 




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 02: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 03:19 PM
Option Group to reports [email protected] Setting Up & Running Reports 2 January 17th, 2005 11: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 05:28 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.