Senin, 08 Februari 2016

[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.





Access 2013  



Posted by: "Bill Singer" <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)



Tidak ada komentar:

Posting Komentar