MS Converted report won't convert all fields if any are null!

[PortlandSam]

Hello Legions of Helpful!
I have a report with about 25 fields that I am converting into a .rtf Ms Word format, and it seems that if any of the results in the query are null, it converts all the field titles, but none of the data. If all fields have been populated by the query, then it converts everything totally cool! So, perhaps all I need to do is make it return some sort of null result like "None", but I don't know where to start on that. Any help is awesome, or if I need to give you more input on my scenario, please let me know!
Portland Sam

 

[MichaelRed]

see the ubiquitous {F1} (aka Help) topic "Nz".



MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[dhookom]

What do you mean by "any of the results in the query are null"? Are you suggesting that if the query returns 1 record and 5 of the fields are Null with the other 20 returning values that the returned values don't show in your RTF file? This would be highly unusual.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.