[AccessD] Differentiating between different data groups within a sub-form

Stuart McLachlan stuart at lexacorp.com.pg
Tue Sep 21 15:44:58 CDT 2010


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
> 





More information about the AccessD mailing list