ExportXML problem !! it don't return columns with NULL values

[ronin]

Hi ,

I have this problem, I use this code

Application.ExportXML ObjectType:=acExportQuery,DataSource:="XMLQuery", _
DataTarget:="I:\PensionMail\" & Me.CurrentConsult & "_" & ConsID & "_" & Format(Now, "dd-mm-yy") & ".xml"

and my DataSource is table resulted from a query which return also columns with empty(null) values if there such .
In the result XML file I can't see the columns that are with null values

How to see them reflected also in xml file ???

thanks

[ronin]

No one ??
Do I have other options ?