How do I repeat a record in the detail section from code

[BRP250]

I'm writing values straight to the report and need to repeat a record to fill some of the controls.

The report has 3 text controls and 3 labels and I line up and print the values direct to the page from a recordset with each line on the report instead of going off the page.

Any ideas???

Bruce

 

[dhookom]

It isn't clear what you have and what you expect. What do you mean by "going off the page"? Why are you writing values to the report rather than binding values from a table or query?

If you have some code, you should share it.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[BRP250]

A bit hard to explain, I didn't do to good a job. But I've improvised and repeated the values through code. Still having problems though.

Running off the page is to wide for the current landscape paper width (sorry), and the report is bound to a query, the 3 controls are bound to this query.

I'm coding a sub report because (probably my lack of knowledge) I don't know how many fields or records will be returned. I can have 8 to around 200+ fields and probably up to 50 records; I have a specific report format to copy.

If I can add an attachment here I could put the code in. But I do think there's an easier way of doing this. Someone suggested I should export to Excel it is able to wrap and repeat columns to a page. That's a last resort.

Bruce

 

[dhookom]

This doesn't help much regarding what you have and what you want to do. Sounds a bit like a crosstab report. If this is the case, check the samples from

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

I will be out of town 'til next Wednesday...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]