Rabu, 10 Februari 2016

RE: [MS_AccessPros] Continuous form formatting

 

Duane,

Thanks.  If I get this to work it will be perfect.

I will let you know.  It is a project for the weekend since, as you mentioned, it will be too cold to go to the beach.

 

Bill

  

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, February 9, 2016 2:52 PM
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Continuous form formatting

 

 

Hi Bill,
If FscID is a numeric value you might be able to use conditional formatting.
1 In design view, select all of the controls in the detail section
2 Select Conditional Formatting from the Format ribbon tab
3 Add New Rule
4 Set the Format Only cells where the to "Expression is"
5 Enter an expression of
     [FscID] Mod 10=1
6 Set the background color
7 Repeat 3 - 6 changing the 1 to 2 to 3 to 4 to ... 0 with 10 different background colors
There should now be 10 different background colors and the chances are 10% that 4 records displayed together will have the same color. If you want more than 10 colors then create more rules and increase the Mod 10 to Mod 15 or Mod 20 .
 
Stay warm. It looks like we might hit 0 degrees F tonight!!!
 
Duane Hookom, MVP
MS Access 
 


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 8 Feb 2016 16:00:14 -0600
Subject: [MS_AccessPros] Continuous form formatting


I have continuous for form that shows TEAM participants in a BASKETBALL game. (two teams per game)

 

The fields in the form are

 

FscID – which is the ID for the GAMES.

FSCDate – Date of Game

graName – which is the name of the grade for the games

gtePoints – which is the point scored by each team.

 

If I have 50 games on the form then I will have 100 records.  Every two records will have the same FscID, which is the ID for the GAMES.  The GAMES and the TEAMS are related in one to many relationship.

 

I have the Alternate Back Color slightly darker for the form so I can read across it.  The colors alternate every other record.  This is nice for reading but it makes it hard to tell what two records go together to form one game.

 

I am wondering if there is a way to format the background so that if the FscID is the same then the backgrounds will be the same.  That way two teams in the same game will have to same color.

 

Is it possible to change the background based in the FscID value?

 

Thanks for your help.

 

 

Bill

Minnesota

Access 2013  

 

 

__._,_.___

Posted by: "Bill Singer" <Bill.Singer@at-group.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar