Set no of rows

[Dazzy]

Hey all

I am recreating some of our official documents as Access reports, and I have them matching perfectly but for one aspect.

If the report has 23 records in the detail section it looks the same but any less than this and then the table has too few rows (fields right next too each other give the illusion of table).

Is there anyway to format 23 rows of data in the detail section even if some of those will be empty?

Thanks

Gary

 

[Mihail]

Seems as you need a subreport.

 

[Dazzy]

Please excuse my ignorance but what difference will a subreport have as surely it will only show the rows that contain data too?

 

[Mihail]

In my opinion, of course IF I understand your issue, a subreport can be resized in order to contain 23 records. No more.

 

[Dazzy]

Ok, picture a word document with a 23 row table, 5 columns, showing all borders. All borders show whether they have data or not.

Access prints cells and borders for those records that have data in them, this will be the same on a subreport.

I need someway, if possible to format empty rows to display borders if there isn't 23 records on the report.

Hope that clears it up a bit. I want to achieve this as a report as it will be easier than teaching people to do it via mail merge.

 

[Mihail]

Yes. I think that I understand this now.
One approach is to use a temporary table with 23 rows and to base your report on this table
Fill the first rows with necessary data and the rest with spaces.

Every time when a new report is created, use a Delete query to empty the table, an Append query to append the new data and this "tool" Recordsets for Beginners - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess.com in order to fill the rest of rows with spaces.

You should (re)format the data at the report level.

 

[stopher]

Take a look at this example.