>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..