[AccessD] Conditional keep together

Is it a function of how many records there are in the group?  I wouldn't
want to hard code a test for a specific data value if I could avoid it.  

You can, of course, set the keep together property through code, but the
question is where to do it?

I've never tried this but I'd experiment with the Format event of the group
header.  

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
Sent: Thursday, January 20, 2011 6:48 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Conditional keep together

I have a report with 2 grouping levels. The first group is keep together
with first record and the second is keep all records together on one page.
99.9% of the time this is perfect.

Now I have the situation where my first keep all records together group fits
perfectly on a page all by itself. This means I have a report header,
further group header, then a page break. Not until page
2 do I see this first set of detail records because if the keep together.

I do not want to set this to keep with first record just to cover this one
instance with one user, but I have to admit it is pretty awful. Is there any
way to determine that this has happened ahead of time and reset the keep
together property?  Better yet only reset it on the group having problems.

I can set the keep together, but only on open. By the time I can tell if it
is needed, my window of opportunity is lost and I am better off just setting
this group to keep together with first record and just be dine with it.

Debbie

Sent from my iPhone
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com