[AccessD] Differentiating between different data groups withina sub-form

 Interesting. 

 I can tell when the numbers change with some
 dummy data.  Ones for the first group, two's
 for the second group, etc.

 How does conditional formatting work in an
 interactive sub-forms embedded in a form ?

 Thanks. . . .


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Tuesday, September 21, 2010 2:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Differentiating between different data groups
withina sub-form


 If the room numbers are consecutive, you could do
 it with conditional formatting. Set the background
 colour based on the condition 

 RoomNum =  Int([RoomNum]/2)*2

 That way, you will colour odd and even numbered
 rooms differently, Of course if rooms are missing
 and you get consecutive odd or even rooms, this
 won't give you a visual break.


On 21 Sep 2010 at 12:36, Edward Zuris wrote:

> 
>  Here is an interesting problem.
> 
>  How do you differentiate between different data
>  groups within an MsAccews sub-form ?
> 
>  I would like to have sub-form which contains many
>  room numbers.  Some are the same room number over
>  and over while there will be other different room
>  numbers.  The room numbers are sorted in ascending
>  order.
> 
>  There will be a clump of 101's, followed by maybe
>  a 102, followed by a group of 103's, etc., etc.
> 
>  I would like to draw a line between each clump, or
>  change the background color for each clump.
> 
>  Or any thing else - that would make it easer to
>  see where one clump of room numbers change over
>  to another clump of room numbers.
> 
>  Any ideas on how to do this ?
> 
>  Thanks.
> 
>  Sincerely,
>  Edward Zuris
>   <mailto:edzedz at comcast.net> edzedz at comcast.net
> 
> 
> 
> 
> --
> 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