what i exactly want to do is to use 4 fields at the row source property of the listbox control, one of character type, the other date, the next numeric and the last one logic. I want the numeric one to be displayed formated. If I use field1,field2,Transform(field3,'###,###.##),iif(field4,'yes',no') I get a sintax error