>i have set listbox rowsourcetype - sql statements and rowsource as "select >lname,fname,mi from bls". i also set columncount to 3.

>how can i display value as alltrim(lname)+", "+alltrim(fname)+" "+alltrim(mi)+"." ???

if you want to put in one column, you can put this way..

Sele alltrim(lname)+", "+alltrim(fname)+" "+alltrim(mi)+"." as custname from bls

on the rowsource of your listbox..