Dan Waters
df.waters at comcast.net
Tue Apr 19 13:32:06 CDT 2011
I think I would just build a string, using the values if I have them, underscores if I don't. If you're using Access 2002+, you can use the OpenArgs parameter when you open the report, if that would work out. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, April 19, 2011 1:26 PM To: Access Developers discussion and problem solving Subject: [AccessD] Exact reports are such a pita 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