Listbox - Column Widths issue

[Ganesh7299]

Hi All,

I have created listbox with one column (contains one column only), now i would like to display all the characters of list item (want scroll bar to listbox).

How do i display all text of list item, I have already fixed Column Widths to max length (22";0.1"). However when scrolling to right, it is going to next blank column of list box, which is created only to change Column Widths property.



Any help highly appreciated . . .

Thanks
Ganesh

[lfpm062010]

Did you use the wizard to re-create the listbox?

What need to be fixed when add more columns in listbox property?
1) Column Count
2) Column Widths
3) Width (should be big enough to hold all the columns or adjust the column to fix the width)
4) Height (should be big enough to hold the min of the records to be displayed or adjust to your form)
5) Row Source (The column list match what is displayed in listbox. Use "Widths" = 0'' to hide the column)
6) Bound Column (Combo box has more use than listbox)

I think that is all there is. Good luck.

[Ganesh7299]

Hi ,

Thanks for your reply,
1) Column Count - already set as 2
2) Column Widths - set to max length
3) Width (should be big enough to hold all the columns or adjust the column to fix the width) - is enough
4) Height (should be big enough to hold the min of the records to be displayed or adjust to your form) - is enough
5) Row Source (The column list match what is displayed in listbox. Use "Widths" = 0'' to hide the column) - it is matching
6) Bound Column (Combo box has more use than listbox) -have tried diff option like 0, 1 and 2

but still facing issues with it

Thanks,
Ganesh

[lfpm062010]

What is the error?

Can you show me the setting for the following with the "(???)"?
1) Column Count - 2
2) Column Widths (???)
3) Width (???)
4) Height (should be big enough to hold the min of the records to be displayed or adjust to your form) - is enough
5) Row Source (???)
6) Bound Column (Combo box has more use than listbox) -have tried diff option like 0, 1 and 2

[Ganesh7299]

I am not getting any error, in fact scroll bar also appeared, however when scrolling to right, it is going to next blank column of list box, which is created only to change Column Widths property.
below are the settings,
1) Column Count - 2
2) Column Widths (20";0.1")
3) Width (1.625")
4) Height (should be big enough to hold the min of the records to be displayed or adjust to your form) - (1.625")
5) Row Source (SELECT [Cust_List].[Customer] FROM Cust_List
6) Bound Column (Combo box has more use than listbox) -(1)

[amrut]

How many maximum characters your data has ? You may use a subform if it suits your purpose. If I am correct, access listbox doesnot support multi line data.

[lfpm062010]

You "Column Widths" is width of each column displayed. The "Width" (1.625") is too small to fit ("20";0.1").

Adjust to "Column Width" to (10";5") and "Width" to (20") to see if it is better.
The total of "Column Width" can not exceed the "Width". You have to account for the Scroll bar.

[Ganesh7299]

@ lfpm062010 - Max "Width" I can set to 2" else entire design of form will be messed. and If setting "Width" to 20 then why should i require scroll bar. Issue is "Width" of listbox is small and unable to display all text of few list items. Hence to view those list items scroll bar is required. Basically it is only one column listbox, however as per my understanding if there is only one column in the listbox, "Column Width" can not changed or will be not effective. Please correct me if I am wrong.

@ amrut - Max 87 characters in the list item data, listbox is multi select listbox and connected with other listbox means lists are getting updated based on other listbox selection, in such case how can i use subform.

[lfpm062010]

I did not know your form was that small. From what I read, that is how it is designed by Microsoft. If you only have one in the list. The horizontal scroll bar won't even show.

Maybe you should try to use a subform to have a better control of your scroll bars.

[rpeare]

Try a combo box instead, you should be able to set the width of the displayed items below the combo box to anything you want using the LIST WIDTH property and it would likely be more efficient (users could type in a few letters and bring up items that match the string thus reducing the items to be scrolled through, assuming the list is alphabetical)

[Ganesh7299]

Is it possible to display text of list item as control tip text of listbox?

[lfpm062010]

Not sure this is what you are asking for. Hope this link will help.

http://msdn.microsoft.com/en-us/libr.../ff864994.aspx

[rpeare]

Yes it is but it would likely involve an unbound 'search' text box that would set criteria for the list box (didn't check LFPM's link to see if that's what he's referring to).

Your criteria for the items in the list box would have to be:

Like "*" & forms!formname!searchfieldname & "*"

if you wanted to find any item that had the search string in the field you're interested in.