Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

Colour fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Saintsman - 27 Nov 2007 12:47 GMT
    VL    L    M    H    VH
VH    0    0    0    0    0
H    0    1    0    3    0
M    0    2    4    6    0
L    0    20    3    6    0
VL    0    2    2    1    0

I have a x-tab populating a popup form measuring frequency occurences (VL=
very low; H=high; L=low etc). Grid is always same size & coloured cells are
not dependant on cell contents
Can I shade the boxes according to position in grid
col1 = orange;
col 2 rows 1 - 2 = orange
col 2 rows 3 - 5 = green
col 3 rows 1 - 2 = green
col 3 rows 3 - 5 = orange
etc
col 5 row 5 - red

Basically a 5 x 5 grid with varying colours
Dale Fye - 27 Nov 2007 18:53 GMT
You could try conditional formatting using an expression based on the value
in your row header.

In my test, I opened a form that was formatted as a datasheet, selected one
of the "columns", then chose Format->Conditional Formatting.

In Condition1, I selected the "Expression Is" option and in the textbox to
the right entered:

[Numbers] IN (3, 7, 9)

Then I set the forground and background colors accordingly

In your case, I think you would highlight the textbox associated with your
VL label and just set the backcolor to orange.  Then, select the textbox
associated with your "L" column label, and under conditional formatting enter
something like:

Default Formatting:
Set the default background for this column to green

Condition 1:
Expression Is:  [RowFieldName] IN ("VH", "H")
then set the backcolor to orange

HTH
Dale

Signature

Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.

>     VL    L    M    H    VH
> VH    0    0    0    0    0
[quoted text clipped - 16 lines]
>
> Basically a 5 x 5 grid with varying colours
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.