[AccessD] No column-wrapping on 2-column reports ?

Christopher Hawkins clh at christopherhawkins.com
Tue Mar 22 13:09:53 CST 2005


Interesting is one word for it.  ;)

I've opted to go with Word mail merge for this particular directory.  My clients will complain, but as we all know - the developer knows best!  ;)

-C-

----------------------------------------
 From: "Charlotte Foust" <cfoust at infostatsystems.com>
Sent: Tuesday, March 22, 2005 11:31 AM
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Subject: RE: [AccessD] No column-wrapping on 2-column reports ? 

A field can't grow and wrap into the next column, to the whole field or whole record, depending on your keep together settings will get moved. As far as I recall, Access reports have always worked this way, which can make creating directories an interesting exercise.

Charlotte Foust

-----Original Message-----
From: Christopher Hawkins [mailto:clh at christopherhawkins.com] 
Sent: Tuesday, March 22, 2005 10:19 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] No column-wrapping on 2-column reports ?

Hello all!

I have an Access report that has been formatted with 2 columns.

Each record has about 10 fields that take up maybe 3 vertical inches of space.  Some of the fields have CanGrow set to true, which means that some records are very "short" in a vertical sense, and others are "tall".

Here's my problem; records do not appear to be wrapping from one column to another.  This is not a problem on pages with a bunch of "short" records, but it is on pages that have (for example) one "short" record and one "tall" record.  Instead of starting below the short record and wrapping from the bottom of the left-hand column to the top of the right-hand column, the "tall" record just starts at the top of the right-hand column, leaving a lot of space under the "short" record in the left-hand column.

Is anyone aware of a way to make records wrap from one column to the other?

-C- 
-- 
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