Access 2003, Hyperlink to change color

[Orson9750]

Hello Access gurus

I have attempted to look through the internet and this forum for help with my question. Although I have found part of my answer, am still puzzled. I have created a “Worker At Risk” hyperlink on my main “Client” form that takes me directly to a subform entitled “RiskFactor”. The RiskFactor subform has client name fields from the Main Client form and childform is a list of various risk factors one might come across when dealing with the client.

Here’s what I would like to happen: When looking at client record in the main Client form if the hyperlink is “red” on that client record then that would indicate to the user to click into the “Worker At Risk” hyperlink and review the contents in the Risk Factor subform to get a heads up on possible danger before approaching this client. If when looking at a client record in the “Client” form is blue then this would indicate no risk and the user would not have to click into the hyperlink because there is no risk with the client.
I hope I have explained this well enough. I have attached a sample of my DB

Thanks for any advise,

 

[SOS]

Hey let's post this again so we can actually read it:

Hello Access gurus

I have attempted to look through the internet and this forum for help with my question. Although I have found part of my answer, am still puzzled. I have created a “Worker At Risk” hyperlink on my main “Client” form that takes me directly to a subform entitled “RiskFactor”. The RiskFactor subform has client name fields from the Main Client form and childform is a list of various risk factors one might come across when dealing with the client.

Here’s what I would like to happen: When looking at client record in the main Client form if the hyperlink is “red” on that client record then that would indicate to the user to click into the “Worker At Risk” hyperlink and review the contents in the Risk Factor subform to get a heads up on possible danger before approaching this client. If when looking at a client record in the “Client” form is blue then this would indicate no risk and the user would not have to click into the hyperlink because there is no risk with the client.
I hope I have explained this well enough. I have attached a sample of my DB

 

[Orson9750]

Please let me know if the text is readable. I changed the font.

 

[SOS]

Please let me know if the text is readable. I changed the font.

Much better.

I took a brief look and saw that the data is not normalized, so it isn't a simple matter to figure out if they have any of the checkboxes checked. It would basically take a UNION query of however many select statements for however many checkboxes there are per record.

But if you did get that then you could have a text box (instead of label) which was formatted to look like a label, with the underlining set and then you could use Conditional Formatting to change the way it looked based on the value of, say another hidden text box, which took the results of your massive union query and did a Dcount on it. If the DCount was >1 then you make it red, if 0 then blue.

Don't know if that makes sense, but it will likely take you a bit to create the UNION query. Personally, I would normalize the database first.

 

[Orson9750]

Thanks much for your answer. Yeah, the db was a quick attempt to show what I was trying to do. The actual db is large and is normalized. I will take your advise and get to work.
Thanks again for your very quick response.