I have managed to build a crosstab report in VB using an ADO record source but have found that all of the text and number formatting is defaulted when the report is created.
I am looking for a simple peiece of code that will allow me to access to cell formatting of each column, row and summary field in order to programatically change it. The code I am looking for will probably be something like this:
crXtabObject.RowGroups.Fields(1).Bold = True
crXtabObject.RowGroups.Fields(1).Font = "Arial"
crXtabObject.ColumnGroups.Fields(1).Format = "DD-MM-YYYY"
Does anyone have any code I can steal for this, please? I have checked through all the help and cannot find this simple piece of code!!
I am looking for a simple peiece of code that will allow me to access to cell formatting of each column, row and summary field in order to programatically change it. The code I am looking for will probably be something like this:
crXtabObject.RowGroups.Fields(1).Bold = True
crXtabObject.RowGroups.Fields(1).Font = "Arial"
crXtabObject.ColumnGroups.Fields(1).Format = "DD-MM-YYYY"
Does anyone have any code I can steal for this, please? I have checked through all the help and cannot find this simple piece of code!!