Position in a combobox
in [General]
|
Prev: LACCDB file won't release
Next: subseribe
From: John on 31 Jan 2010 12:55 Access V97. I have a 5 to 8 row combo box [cboOC1] with column heads. I do a gotocontrol to [cboOC1] and also a dropdown. Everything OK to this point. This leaves the selection on the header row, so the user has to cursor down (down arrow) one time before an actual selection is highlited. I would like to place the selection on the first actual selection. Looks like the Selected property is what I need, but that's for listboxes. Is there a method to do this for a combo? Thankyou John
From: Steve on 31 Jan 2010 13:48 Select the combobox and go to properties. Where it says Show Column Heads, change to No. Add a label(s) above the combobox to identify the column(s). Steve santus(a)penn.com "John" <newsgroups(a)microsoft.com> wrote in message news:%23YXxk6poKHA.4648(a)TK2MSFTNGP06.phx.gbl... > Access V97. > I have a 5 to 8 row combo box [cboOC1] with column heads. > I do a gotocontrol to [cboOC1] and also a dropdown. > Everything OK to this point. > > This leaves the selection on the header row, so the user has > to cursor down (down arrow) one time before an actual selection > is highlited. > > I would like to place the selection on the first actual selection. > Looks like the Selected property is what I need, but that's > for listboxes. > > Is there a method to do this for a combo? > > Thankyou > John >
From: Linq Adams via AccessMonster.com on 31 Jan 2010 14:46 To have it on the first row of data when opening the form and moving to the combobox : Private Sub Form_Load() Me.ComboBox = Me.ComboBox.ItemData(1) End Sub To have it on the first row of data each time you move to a different record, place the same code in the Form_Current event. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/201001/1
From: John on 31 Jan 2010 15:09 Steve, Unfortunately that might work for a fixed control, like a listbox, but a combo list can open in different positions depending on how many records are returned. If a dropdowned list of a combo hits the screen edge or screen bottom, it shifts itself to a new position, in an attempt to show the complete list. All eight of these combos by necessity are located low on the form, and usually deliver 3 to 8, but as many as 10 selections, so they will all dropdown into a different position accordingly. Thanks for your reply, John "Steve" <notmyemail(a)address.com> wrote in message news:uJtWNYqoKHA.1548(a)TK2MSFTNGP04.phx.gbl... > Select the combobox and go to properties. Where it says Show Column Heads, > change to No. Add a label(s) above the combobox to identify the column(s). > > Steve > santus(a)penn.com > > > > "John" <newsgroups(a)microsoft.com> wrote in message > news:%23YXxk6poKHA.4648(a)TK2MSFTNGP06.phx.gbl... >> Access V97. >> I have a 5 to 8 row combo box [cboOC1] with column heads. >> I do a gotocontrol to [cboOC1] and also a dropdown. >> Everything OK to this point. >> >> This leaves the selection on the header row, so the user has >> to cursor down (down arrow) one time before an actual selection >> is highlited. >> >> I would like to place the selection on the first actual selection. >> Looks like the Selected property is what I need, but that's >> for listboxes. >> >> Is there a method to do this for a combo? >> >> Thankyou >> John >> > >
From: John on 31 Jan 2010 15:12
I forgot two critical items in my question. 1. cboOC1 is an unbound combobox 2. I don't want to select the first legitimate record, just position the selector there. Thanks everyone... John "John" <newsgroups(a)microsoft.com> wrote in message news:%23YXxk6poKHA.4648(a)TK2MSFTNGP06.phx.gbl... > Access V97. > I have a 5 to 8 row combo box [cboOC1] with column heads. > I do a gotocontrol to [cboOC1] and also a dropdown. > Everything OK to this point. > > This leaves the selection on the header row, so the user has > to cursor down (down arrow) one time before an actual selection > is highlited. > > I would like to place the selection on the first actual selection. > Looks like the Selected property is what I need, but that's > for listboxes. > > Is there a method to do this for a combo? > > Thankyou > John > |