I would format the data in the query to make it look how it is supposed to look using an IIf statement if needed. The report would then just show the data as I formatted it. Another solution may be to use one field for only one type of data. What are the possibilities you are required to format ( date, text, number, Nulls, ...)? I ask because if the field is always a number then the format property may be enough to do what you need.