I have an Access 97 report that has 2 columns in the detail section. I just want to do a column break on certain detail records.
The table the report is based on has a Yes/No field, let's call it MyColBreak. When a detail record is printed and MyColBreak is true, I want to force the report to go to the next column. I have tried setting the NewColOrRow property in the report, using code in the report's Detail_Format, but that didn't work. I also put this code in the Group Header Format event.
Note that these detail records are also grouped and I have the KeepTogether property set to True so no group will span between columns.
How do I do this?