HELP! conditional formatting keeps changing

N

nojyttap

I have 5 optional sections to record revisions to the form. The fisrt section
may be entered without restrictions. The 2nd to 5th section cannot be entered
until a checkbox in the previous section is TRUE.
Once the checkbox in a section is TRUE that section and the controls inside
are locked and cannot be changed or deleted.

There may be an easier way but this is how I did it:

There are 5 hidden text boxes (rev1OK, rev2OK, etc.) that start with a value
of 2 (except for revOK1 which starts with 0). When the checkbox in the first
section is TRUE rev1OK is set to 1 and rev2OK is set to 0. This works the
same for the subsequent sections (rev2OK = 1 and rev3OK = 0, rev3OK=1 and
rev4OK = 0).

In the first section the conditional formatting is 'rev1OK = 1 do not allow
users to insert or delete this control. In the second section the conditional
formatting is 'rev2OK not= 0 do not allow users to insert or delete this
control. The subsequent section has similar conditional formatting.

When I first set this up it worked as I expected.

BUT...when I reboot my computer and try to use the form these sections do
not behave properly...some sections open when they shouldn't others won't
open at all.

Here is what I found, the conditional formatting in the first section is
"rev4OK = 2", the second section "rev4OK = 1", the third "rev5OK = 2", forth
"rev5OK = 1" and fifth "rev1OK = 1"

This only happens after a reboot. If I just close and reopen the form it
does not change. PLEASE HELP! How do I prevent this from happening?
 
N

nojyttap

Ok so I made some changes. It works the same as before except now there is
another textbox being set by the first and this is what the section checks.

Now what happens is if I make any, that's ANY change to the document (change
the font color of the text boxes etc.) the conditional formatting fails. Even
though it is still there correctly it has no effect...the sections can be
inserted without restriction.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top