Prev: Can Someone please help me with my Computer stuff? 86995
Next: In need of a best friend!
From: Bob Quintal on 28 Jan 2010 19:13
Roger <lesperancer(a)natpro.com> wrote in news:e25be18d-b3b8-4ab3-a961-
64dace951c46(a)b2g2000yqi.googlegroups.com:

> the rowsource for my comboBox is
> select id, title from someTable
>
> where title is text(100)
>
> the comboBox columnWidth is 0;1"
>
> in order to see all the data, the height of the comboBox is .666,
> showing 4 lines of text
> everything is cool so far
>
> now when I dropdown to the list of 'titles', the list starts at the
> bottom of the comboBox
> if the height of the comboBox is .1666, this looks ok
>
> is there a way to start the list at the top of the comboBox ?

How about an alternative method:
add a column to the table, call it Keyword, make it Text(15) or so.
Display that in the combobox.

Download Stephen Lebans' tool tip utility from
http://www.lebans.com/tooltip.htm
Set up your combo box to show the long field (and it's not a title,
it's a whole story) in the tooltip.

I did that and it works very well.




--
Bob Quintal

PA is y I've altered my email address.
From: Salad on 28 Jan 2010 22:55
Roger wrote:

> On Jan 28, 12:11 pm, Salad <sa...(a)oilandvinegar.com> wrote:
>
>>Roger wrote:
>>
>>>On Jan 27, 4:53 pm, Salad <sa...(a)oilandvinegar.com> wrote:
>>
>>>>Roger wrote:
>>
>>>>>the rowsource for my comboBox is
>>>>> select id, title from someTable
>>
>>>>>where title is text(100)
>>
>>>>>the comboBox columnWidth is 0;1"
>>
>>>>>in order to see all the data, the height of the comboBox is .666,
>>>>>showing 4 lines of text
>>>>>everything is cool so far
>>
>>>>>now when I dropdown to the list of 'titles', the list starts at the
>>>>>bottom of the comboBox
>>>>>if the height of the comboBox is .1666, this looks ok
>>
>>>>>is there a way to start the list at the top of the comboBox ?
>>
>>>>Why don't you set the ListWidth property to something like 7" and the
>>>>ColumnWidth property to 0;7?- Hide quoted text -
>>
>>>>- Show quoted text -
>>
>>>tried it... doesn't position the start of the list at the top edge of
>>>the comboBox
>>>it still at the bottom edge
>>
>>>and length of the text won't fit on the screen (> 11" or whatever)
>>>without horizontal scrolling, thus the need for a multi-lines display
>>>area
>>
>>What font are you using? Arial 22 Bold? There should be no reason to
>>scroll if you set the ListWidth property to hold the size of the total
>>combo. Are there tabs or crlf's in the field?
>>
>>I don't know if you have a default value in the combo box. Or if you
>>set the index of the combo to something. You are doing something
>>incorrectly.
>>
>>I did this.
>>
>>Private Sub Form_Current()
>> Dim intCount As Integer
>> If Me.Combo1.ListCount > 0 Then
>> 'there's something in the combobox regardless
>> 'the show ColumnHeadings property
>>
>> 'determine the first value in the combo depending
>> 'on the column headings setting
>> intCount = IIf(Me.Combo1.ColumnHeads, 1, 0)
>>
>> 'now go there
>> Me.Combo1 = Me.Combo1.ItemData(intCount)
>> End If
>>End Sub
>>
>>You could even modify the above to a function, assume DefVal(), and enter
>> =DefVal()
>>in the Default property of the combo to seleet/highlight the first row.
>>
>>Look in Help for the property settings I used above for clarification.- Hide quoted text -
>>
>>- Show quoted text -
>
>
> font is arial 8, the width of the control is 6.5", the width of my
> form when maximized without horizontal scrolling is about 10"
>
> the data being displayed is text(200)

In your original post, it was 100 and now the size has doubled.
Personally, I wouldn't even bother with a combo box. I'd create a
continuous or datasheet form that's searchable.

It appears my code above doesn't work for you as well for going to the
first combo entry. I'd use Bob's suggestion.
First  |  Prev  | 
Pages: 1 2
Prev: Can Someone please help me with my Computer stuff? 86995
Next: In need of a best friend!