Listbox.AddItem problem

[Azita79]

Hi All,

I am trying to add string variables which contain commas to a listbox.

let say my variable is "DAVID CRAIG CONSTRUCTION, INC"
the listbox looks like

DAVID GRAIG CONSTRUCTION
INC

so If my variable has 2 commas I get 3 lines!!

how can I fix this problem?

Azita

 

[kraxmo]

Embed the value within quotes and it will work.

Example with a listbox named List0:

    Me!List0.RowSourceType = "Value List"
    Me!List0.RowSource = Chr$(34) & "DAVID CRAIG CONSTRUCTION, INC" & Chr$(34) & ";"
    Me!List0.RowSource = Me!List0.RowSource & Chr$(34) & "TEST" & Chr$(34) & ";"
    Me!List0.RowSource = Me!List0.RowSource & Chr$(34) & "The """"Quoted"""" String" & Chr$(34)

Jim Kraxberger
Developing Access solutions since 1995

 

[Azita79]

Hi,

Thank you so much Jim, it works fine now.


Azita