[AccessD] Exact reports are such a pita

If you want to use a continuous subform, you could count the records
you have and then add dummy records to fill out the count.  You would
want to either use a temp table or create a new recordset and add the
dummy records to that, then dispose the recordset when done.

Charlotte Foust

On Tue, Apr 19, 2011 at 11:26 AM, jwcolby <jwcolby at colbyconsulting.com> wrote:
> I need to build a report that looks as close as possible to a state form.
>  This includes a couple of subforms which look like:
>
> 1) From:_____________ To:___________
> 2) From:_____________ To:___________
> 3) From:_____________ To:___________
>
> And if I don't have a line 2 or line 3 I still need to fake it, put in the
> number and underline.
>
> IOW it should be indistinguishable from a copy of their form casually
> compared side by side.
>
> Can you say PITA.
>
> The only thing I can think of is to build a temp table, place the 1) 2) and
> 3) in three records (programmatically) and then fill in each record as
> needed.
>
> That seems rather over the top.  Any suggestions for easy ways to fake this?
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>