Toggle box that changes color font on form

johnherrerajuan

Registered User.
Local time
Today, 05:20
Joined
Feb 25, 2013
Messages
44
Well hello everyone
I created a form that has about 200 fields and all the fields are utilized at a point depending on the work order assigned to us. I wanted to know if it’s possible to put like a toggle box or a check box etc. next to the field so if it is checked it would be in a Dark color and the ones not utilized are in a shade of gray. All the fields are coming from the same table. Another thing it’s an estimate worksheet so a row would have something like, Labor, QTY, HRs, Overtime, total as columns, so I would want a check box to have control over those but one for each row, EX contractor, locksmith….
Hopefully I am making sense
 

Attachments

  • Image 1.jpg
    Image 1.jpg
    93 KB · Views: 109
Yes you could do that but tables are limited to 255 columns and you are already close to the max. Having them unbound wouldn't be useful since you would have to check them every time you viewed the record.

A better solution is to normalize your tables. You have at least two repeating groups, one of which is which is less obvious than most. Materials needs to be in a separate table since it has a 1-many relationship with whatever your main topic is. Labor is also 1-many but is more finely defined and limited than material but it is a repeating group never the less and belongs in a separate table.

Once you remove these columns to a labor table and a materials table, you will see that your tables only contain rows for items that are relevant. So if you only need a locksmith and a painter, your subform will have only those two rows. Same with material. You will have one row for each type of material you need.
 
Yes you could do that but tables are limited to 255 columns and you are already close to the max. Having them unbound wouldn't be useful since you would have to check them every time you viewed the record.

A better solution is to normalize your tables. You have at least two repeating groups, one of which is which is less obvious than most. Materials needs to be in a separate table since it has a 1-many relationship with whatever your main topic is. Labor is also 1-many but is more finely defined and limited than material but it is a repeating group never the less and belongs in a separate table.

Once you remove these columns to a labor table and a materials table, you will see that your tables only contain rows for items that are relevant. So if you only need a locksmith and a painter, your subform will have only those two rows. Same with material. You will have one row for each type of material you need.

I like your idea but I'm afraid it is a little to late to turn back that far, I want to know if it is possible to have a unbounded check mark control the color of a text. If so can you help me out on that.
 
I figured it out i used conditional formatting, but thank you for your time
 

Users who are viewing this thread

Back
Top Bottom