[AccessD] Report

Reuben Cummings reuben at gfconsultants.com
Mon May 17 10:03:11 CDT 2004


You have to lay the labels and text boxes on top of one another in a single
column.  The width is whatever you need it to be in order to fit in your
text.

In On_Format of the detail section:

If me.left < (ColumnWidthInInches * 1440) then

	'code to hide all text boxes
	'code to show all labels

	Me.NextRecord = false

Else

	'code to show all text boxes
	'code to hide all labels

End if

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bob Heygood
> Sent: Sunday, May 16, 2004 6:47 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Report
>
>
> And of course as soon as I sent the message, I remembered "Columns" in the
> page setup menu. And that is the solution. Thanks anyway.
> Now I just need to only have the labels appear once for each horizontal
> section instead of for each record.
>
> TIA
>
> bob
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bob Heygood
> Sent: Sunday, May 16, 2004 3:10 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Report
>
>
> Hello to the group,
>
> I want to create a report that will display 3 or 4 detail
> sections across a
> page then wrap to the next record below and so on.....
>
> or :
>
> record one					record two
> 		record three
> something about record one		something about record two
> something about
> record three
> something else about record one	something else record two
> something else
> record three
> something more record one		something more record one
> something more record
> one
>
>
> record four					record five
> 		record six
> something about record four		something about record five
> something about
> record six
> something more record one
>
> Sub reports come to mind but I can't work it out. Any ideas would be
> welcome.
>
> bob
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>






More information about the AccessD mailing list