>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

I am unsure of the correct syntax in the listbox, maybe someone else could help you. You could try to copy what you've got and paste it to the command window and try it out there. That would at least tell you if you've got any spelling errors.