Yes/No Check Boxes Hide if Null

  • Thread starter Thread starter Elvis72
  • Start date Start date
E

Elvis72

I have a form that shows a specific resume called up by Worker ID.

I have a subform that shows the languages they speak, they are yes/no fields.

I want to only show the fields that have a true value on the subform.

Not sure how to go about this?
 
You cannot selectively hide fields in different rows of a continuous form or
datasheet.

It is possible to fudge it with some conditional formatting if you use text
boxes instead of check boxes, but it really is not worth the effort. You
would be much better off if you created a correct relational design so you
can record that one worker can speak many languages.

For an example of how to do this, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html
 
To expand on Allen's point concerning design...

If I interpret your description literally, each time a new
"language-of-interest" is added, you'd have to modify ("maintain") your
form, any related queries or reports or code or ...

Much easier to use the relational database relationally, and build a "one
person-many languages" relation/join/junction table.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Allen -

I have reviewed your pages and even your sample database, I have gotten all
the way through creating the new process, but when I get to the combobox on
the Client form I only end up with the ID number not the Disease, and I
cannot figure out what I have done wrong?
 
Back
Top