<div>
It took me a while to figure out that I needed to code a SQL statement and since I didn't have a SQL book that dealt with VB, it took me a bit longer to get the correct syntax. &nbsp;Thank you so very much for your help!!<br />

</div>


It took me a while to figure out that I needed to code a SQL statement and since I didn't have a SQL book that dealt with VB, it took me a bit longer to get the correct syntax.  Thank you so very much for your help!!


<div>
<div class="content wysiwyg-content">
 &nbsp; &nbsp;I have an Access database that I have bound through an ADO control to a DataList box. &nbsp;I'm trying to display two of the columns in this list box with a dash in between them. &nbsp;The code to display just one of the columns is:<br />
&nbsp;<br />
datalist1.listfield = &quot;Country&quot;<br />
&nbsp;<br />
The &quot;Country&quot; is one of the column names in this table and when executed, it lists the elements of that column. &nbsp;Do you have any suggestions as to how I can simply list the elements of two columns with a dash in between them? &nbsp;
</div>
</div>


    I have an Access database that I have bound through an ADO control to a DataList box.  I'm trying to display two of the columns in this list box with a dash in between them.  The code to display just one of the columns is:
 
datalist1.listfield = "Country"
 
The "Country" is one of the column names in this table and when executed, it lists the elements of that column.  Do you have any suggestions as to how I can simply list the elements of two columns with a dash in between them?  

DBDataList Control

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.