By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,028 Members | 1,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,028 IT Pros & Developers. It's quick & easy.

Change Field & Font Colors Using Code

P: 8
My dilemma is as follows. I have a continous form that I am using as a Visual Display Form to show the status of records (SoeCodes). What their status currently is and what they have been. I have 6 Yes/No check boxes (status). I am wanting to change color depending on which of the 6 check boxes is checked and I want to leave each checkbox checked. My form is a continuous form and since I need 6-7 colors Conditional Formatting will not work. I can change the color of the fields with code but since this is a continuous form it is changing the field for every record on the form and not just the record I am on. Any suggestions how to do this and restrict it to the record I am currently on.

My check boxes are:

SoeError
SoeFixed
Rework
Pending
Approved
Completed

My Fields that change color are

Pri
Form #
Process
Soe_Code
Date(only caption)
Needed
Assigned
Apr 18 '07 #1
Share this Question
Share on Google+
2 Replies


Denburt
Expert 100+
P: 1,356
Yes you do have an interesting dilemma, I think you should start with the following post it has a link which may help. this is one of those things that could get nasty depending on your skill level. I haven't looked at the link but I would be glad to help.

http://www.thescripts.com/forum/post2458948-7.html
Apr 20 '07 #2

P: 8
Denburt,

I will review what you have sent the link for and check it out. It looks pretty complicated but I will definitely look at it and I thank you for your reply.
Apr 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.