Not IsEmpty ( FilterValues ( CheckboxFieldHere ; "Word" ) )
This will be True when "Word" is a value selected in your set of check boxes. Patterncount can be used instead, but due to the way it works, it can produce "false positive" results with some combinations of value list values and "word" values.
PatternCount ( List ( "AppleSauce" ; "Salad" ; "French Fries ) ; "Apple" ) will return a True result even though "Apple" is not a member of the list of values. FilterValues avoids this issue.
and I'd put
Not IsEmpty ( FilterValues ( YourTable::CheckboxFieldHere ; "Word" ) )
Right in the Hide When box. no scripting should then be needed.
Does that still work if I replace the field with the Variable that i made of that field (I made it a variable because I use it multiple times for different things within the database, its found from the account users info).
If you set the variable to the value of your check box field, yes.
Thanks Phil, it wasn't working for me at first which is why I questioned it, then realized I was actually doing the formula the wrong way around.....working now! I was naming the word which I wanted it to show for .........duh