Entering txt into a listbox

[JB510]

I have a listbox that I cannot figure out why it is not displaying:

Row Source Type = Value List
Bound Column = 1
Limit to list= No
Allow Value List Edits = Yes



When use the command
Me.List1.AddItem Item:=Str
(Str is a string value)

I can List1.listcount and it is 1 but the value does not show in the box.
I tried List1.Requery and still nothing.. Am I doing something wrong?

[JB510]

I have a Combobox that I cannot figure out why it is not displaying:

Row Source Type = Value List
Bound Column = 1
Limit to list= No
Allow Value List Edits = Yes

When use the command
Me.Combobox1.AddItem Item:=Str
(Str is a string value)

I can Combobox1.listcount and it is 1 but the value does not show in the box.
I tried Combobox1.Requery and still nothing.. Am I doing something wrong?

I changed it to a Listbox and it worked?? - Why?

[June7]

Why does your original post reference listbox yet quote references combobox. Edit original post.

Adding item to combobox list does not cause it to be selected and display in the box - must set combobox Value property.

Adding item to listbox list will display the item but again, it is not selected.

[Edgar]

The typical setup of a combobox involves also specifying how many columns it will have, which is probably 2 for you, and formatting the columns, something to "0;2", which means 0 width first column, 2 width for second column, etc. All of that is in the format tab of the combobox.

[JB510]

I did not want to confuse things so I said it was a listbox but no, as corrected, it was a combo box.

I don't need it selected, I just wanted to drop serial number(s) in there imported from a text file. (I started with one Serial number in a text file.)
My code put the number in the Row Source of the combo box (I don't know if it is to go in there) but it does not show up in the box on the screen.
?

[June7]

What do you mean by 'does not show up in the box on the screen'? It won't until item is selected or combobox Value is set.

[JB510]

What do you mean by 'does not show up in the box on the screen'? It won't until item is selected or combobox Value is set.

Me.Combobox1.AddItem Item:=Str
txtGood = combobox1.listcount
txtTotal = combobox1.listcount
txtBad.setfocus

Where Str is the serial number.
It did not put the serial number into the combo box.
It did however make txtGood = 1 and txtTotal = 1

[Edgar]

That means it's adding the item but it's not showing it. What is the rowsource of your combobox? Also, where is Str coming from?

[JB510]

Row Source was Value List.
Str is a string value. I can step over it using F8 and it is populated correctly B5L604001234

That is why I posted.. I could not figure out what I was doing wrong.
I deleted the combo box and tried the same code with a list box. The list box worked.

[Gicu]

I would recommend you use a table\query for the row source and not a value list. There is a character number limitation for the value lists and also it makes it harder to remove bad\duplicate entries.

Some reading for you:
https://www.datawright.com.au/access...ur%20rowsource.
http://allenbrowne.com/ser-27.html

Cheers,

[JB510]

Noted.. It is only to list a max of 20 serial numbers anyway so I am not worried about running out of space.
It still does not explain why it would not show them in the combo box.

[Edgar]

If you are adding a string with this:
Me.Combobox1.AddItem Item:=Str

And it works, but it does not show what you want, then something else is happening in your code, JB510. How does the rest of the code look?

[JB510]

The rest of the code is a work in progress.. as mentioned, I got it to work by making it a listbox.
Mark it up as unknown...