Hi everybody,

I made great reports on Access 2003 by including a lot of conditionnal formatting . There is a lot of colours, my reports are really nice. But I would like to export it to Excel and I don't want to lose the page setup. In fact, when I export it to Excel or Word, I obtain just a simple table. All the coloured conditionnal formatting are lost !
Is there a way to keep it in order to modify on Excel/word the reports I made on Access previously ?

Thanx a lot.

No. Exports to both Word and Excel loose their "pretty printing". You could use OLE to format the report once it has been exported. Having automated both Word and Excel, my choice is Excel by a long shot. It is much easier to control.

I agree with Pat, and would offer the alternative of exporting to snapshot format or pdf, both of which should keep the formatting.