Skip to content

Combining Data from Two Fields in a ListBox Column

How to use the AddItem method to transfer data from two fields into a single column in a listbox.

Q:  Kris Rutko wants to know how to transfer data from two columns of table information into a single column in a listbox, using the AddItem method.

A:  Save the value from each field to a variable of the appropriate data type, then concatenate these two variables into a String variable:

strItem =  strStripNumber & ” (” & CStr(intAcreage) & “)”

 

Then use the strItem variable with the AddItem method to add it to the listbox’s list.

About this author

Office 2024 - all you need to know. Facts & prices for the new Microsoft Office. Do you need it?

Microsoft Office upcoming support end date checklist.