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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

combobox style



 
 
Thread Tools Display Modes
  #1  
Old October 30th, 2008, 07:58 PM posted to microsoft.public.access.tablesdbdesign
MB
external usenet poster
 
Posts: 211
Default combobox style

How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times instead
only showing records when arrow is clicked?)? I've seen articles on the 3
styles available, but none with an explanation on how to actually set it to
the simple style.
  #2  
Old October 30th, 2008, 09:07 PM posted to microsoft.public.access.tablesdbdesign
fredg
external usenet poster
 
Posts: 4,386
Default combobox style

On Thu, 30 Oct 2008 11:58:01 -0700, mb wrote:

How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times instead
only showing records when arrow is clicked?)? I've seen articles on the 3
styles available, but none with an explanation on how to actually set it to
the simple style.


The 'style' of a combo box?
A combo box is a combo box.

If you are looking to display the values at all times, then you want
to use a LIST BOX.

In Design view, right click on the combo box and select Change to List
box.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #3  
Old October 30th, 2008, 09:20 PM posted to microsoft.public.access.tablesdbdesign
MB
external usenet poster
 
Posts: 211
Default combobox style

No. I want to display a combo box that show all the values in the list and
allows users to type in values that are not in the list in the textbox of the
combobox. What I've read so far is this:

There are three combo box styles. Each style can be set at design time and
uses values, or equivalent Visual Basic constants, to set the style of the
combo box.

Style Value Constant
Drop-down combo box 0 vbComboDropDown
Simple combo box 1 vbComboSimple
Drop-down list box 2 vbComboDropDownList


"fredg" wrote:

On Thu, 30 Oct 2008 11:58:01 -0700, mb wrote:

How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times instead
only showing records when arrow is clicked?)? I've seen articles on the 3
styles available, but none with an explanation on how to actually set it to
the simple style.


The 'style' of a combo box?
A combo box is a combo box.

If you are looking to display the values at all times, then you want
to use a LIST BOX.

In Design view, right click on the combo box and select Change to List
box.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

  #4  
Old October 30th, 2008, 09:25 PM posted to microsoft.public.access.tablesdbdesign
MB
external usenet poster
 
Posts: 211
Default combobox style

I know there are 3 styles of comboboxes. I just need to know how to set it
to the style I want. If anyone knows the coding to put in vba or the steps
to take in design view, it would be greatly appreciated.

"mb" wrote:

No. I want to display a combo box that show all the values in the list and
allows users to type in values that are not in the list in the textbox of the
combobox. What I've read so far is this:

There are three combo box styles. Each style can be set at design time and
uses values, or equivalent Visual Basic constants, to set the style of the
combo box.

Style Value Constant
Drop-down combo box 0 vbComboDropDown
Simple combo box 1 vbComboSimple
Drop-down list box 2 vbComboDropDownList


"fredg" wrote:

On Thu, 30 Oct 2008 11:58:01 -0700, mb wrote:

How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times instead
only showing records when arrow is clicked?)? I've seen articles on the 3
styles available, but none with an explanation on how to actually set it to
the simple style.


The 'style' of a combo box?
A combo box is a combo box.

If you are looking to display the values at all times, then you want
to use a LIST BOX.

In Design view, right click on the combo box and select Change to List
box.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

  #5  
Old October 31st, 2008, 12:28 AM posted to microsoft.public.access.tablesdbdesign
Rick Brandt
external usenet poster
 
Posts: 4,354
Default combobox style

mb wrote:
No. I want to display a combo box that show all the values in the
list and allows users to type in values that are not in the list in
the textbox of the combobox. What I've read so far is this:

There are three combo box styles. Each style can be set at design
time and uses values, or equivalent Visual Basic constants, to set
the style of the combo box.

Style Value Constant
Drop-down combo box 0 vbComboDropDown
Simple combo box 1 vbComboSimple
Drop-down list box 2 vbComboDropDownList


You are confused.

A ComboBox never shows its list unless you drop it with the arrow or with
code. It cannot be made to be dropped when it does not have focus.

A ComboBox has a property LimitToList that determines whether the user can
type an entry that is not in the list. In a Multi-Column ComboBox this is
only allowed when the bound column is also the displayed column.

A ComboBox never allows multiple selections.

A ListBox always displays as many rows as its height allows. Youc an scroll
to see the rest. It never allows you to deviate from its list.

A ListBox has a MultiSelect property that can be set to "None", "Simple" or
"Extended". The first means only one row can be selected while the latter
two allow multiple selections. The latter two also make a ListBox useless
as a bound control because a Multi-Select ListBox always has a value of
Null.

You seem to be describing something that has properties of both a ComboBox
and a ListBox. There is no such native control in Access. You might have
been lead astray by Access help which will often take you to a help topic
for a completely different Office product than the one you started in.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


  #6  
Old October 31st, 2008, 12:39 AM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default combobox style

You are describing a control that is specific to a data access page, rather
than a standard Access form. Here's the text from Access HELP:

(drop-down list box: A control on a data access page that, when clicked,
displays a list from which you can select a value. You cannot type a value
in a drop-down list box.)

Are you using a data access page?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"mb" wrote in message
...
How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times
instead
only showing records when arrow is clicked?)? I've seen articles on the 3
styles available, but none with an explanation on how to actually set it
to
the simple style.



  #7  
Old October 31st, 2008, 04:04 AM posted to microsoft.public.access.tablesdbdesign
MB
external usenet poster
 
Posts: 211
Default combobox style

I'm not confused. I found the information through Microsoft
(http://msdn.microsoft.com/en-us/libr...2(VS.60).aspx). It's a
combobox, and I don't need it to allow multiple selections. I just need the
style that keeps the list open.

"Rick Brandt" wrote:

mb wrote:
No. I want to display a combo box that show all the values in the
list and allows users to type in values that are not in the list in
the textbox of the combobox. What I've read so far is this:

There are three combo box styles. Each style can be set at design
time and uses values, or equivalent Visual Basic constants, to set
the style of the combo box.

Style Value Constant
Drop-down combo box 0 vbComboDropDown
Simple combo box 1 vbComboSimple
Drop-down list box 2 vbComboDropDownList


You are confused.

A ComboBox never shows its list unless you drop it with the arrow or with
code. It cannot be made to be dropped when it does not have focus.

A ComboBox has a property LimitToList that determines whether the user can
type an entry that is not in the list. In a Multi-Column ComboBox this is
only allowed when the bound column is also the displayed column.

A ComboBox never allows multiple selections.

A ListBox always displays as many rows as its height allows. Youc an scroll
to see the rest. It never allows you to deviate from its list.

A ListBox has a MultiSelect property that can be set to "None", "Simple" or
"Extended". The first means only one row can be selected while the latter
two allow multiple selections. The latter two also make a ListBox useless
as a bound control because a Multi-Select ListBox always has a value of
Null.

You seem to be describing something that has properties of both a ComboBox
and a ListBox. There is no such native control in Access. You might have
been lead astray by Access help which will often take you to a help topic
for a completely different Office product than the one you started in.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



  #8  
Old October 31st, 2008, 04:19 AM posted to microsoft.public.access.tablesdbdesign
MB
external usenet poster
 
Posts: 211
Default combobox style

Thanks for your help. I don't know if the site I was looking at
(http://msdn.microsoft.com/en-us/libr...32(VS.60).aspx was
specifically for a data access page, but I'm hoping to use this in an Access
database form.

"Jeff Boyce" wrote:

You are describing a control that is specific to a data access page, rather
than a standard Access form. Here's the text from Access HELP:

(drop-down list box: A control on a data access page that, when clicked,
displays a list from which you can select a value. You cannot type a value
in a drop-down list box.)

Are you using a data access page?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"mb" wrote in message
...
How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times
instead
only showing records when arrow is clicked?)? I've seen articles on the 3
styles available, but none with an explanation on how to actually set it
to
the simple style.




  #9  
Old October 31st, 2008, 12:32 PM posted to microsoft.public.access.tablesdbdesign
Rick Brandt
external usenet poster
 
Posts: 4,354
Default combobox style

mb wrote:
Thanks for your help. I don't know if the site I was looking at
(http://msdn.microsoft.com/en-us/libr...32(VS.60).aspx was
specifically for a data access page, but I'm hoping to use this in an
Access database form.


That page pretty clearly describes itself as a VB6 page, not an Access page.
The control it describes cannot be used in Access unless there is an ActiveX
version of it that you could utilize (bad idea).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


  #10  
Old October 31st, 2008, 04:26 PM posted to microsoft.public.access.tablesdbdesign
MB
external usenet poster
 
Posts: 211
Default combobox style

Ok. I figured VB6 just meant it was a newer version of VBA (where I put the
codes/modules). At any rate, I gave up on the idea last night when I found a
work around (not pretty, but it works). Thanks everyone for your help.

"Rick Brandt" wrote:

mb wrote:
Thanks for your help. I don't know if the site I was looking at
(http://msdn.microsoft.com/en-us/libr...32(VS.60).aspx was
specifically for a data access page, but I'm hoping to use this in an
Access database form.


That page pretty clearly describes itself as a VB6 page, not an Access page.
The control it describes cannot be used in Access unless there is an ActiveX
version of it that you could utilize (bad idea).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



 




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


All times are GMT +1. The time now is 02:59 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.