conditional formatting

  • Thread starter Thread starter chris morrison
  • Start date Start date
C

chris morrison

Im still working on this problem. I have two checkboxes in
my table. If one field checkbox is true, (field "A") I
want fields c,d,e,and f of a record to print. No problem.
If, however, field "B" is checked true instead of
field "A", I want fields e and f printed as well. Here is
the problem - I dont want fields e and f to print if
field "A" is checked true, only "B". After researching, I
changed Field "B" from a checkbox to a text box and set
the formating to white background and white text if
Field "B" is = to "0" (false). It works!

But how do I get fields e and f to do the same as field "B"
and not to be visible if Textbox "B" is = to 0(false)?

any assistance is greatly appreciated!
 
chris said:
Im still working on this problem. I have two checkboxes in
my table. If one field checkbox is true, (field "A") I
want fields c,d,e,and f of a record to print. No problem.
If, however, field "B" is checked true instead of
field "A", I want fields e and f printed as well. Here is
the problem - I dont want fields e and f to print if
field "A" is checked true, only "B". After researching, I
changed Field "B" from a checkbox to a text box and set
the formating to white background and white text if
Field "B" is = to "0" (false). It works!

But how do I get fields e and f to do the same as field "B"
and not to be visible if Textbox "B" is = to 0(false)?
Click to expand...

Personally, I think it's easier to do this kind of thing in
VBA (in the Format event procedure of the section containing
all these controls). THe code might be a little tedious,
but at least the logic is easy to follow.

Even though your request is ambiguous, the general idea is
something like:

If textA = True Then
textC.Visible = True
textD.Visible = True
textE.Visible = True
textE.Visible = True
ElseIf textB = True Then
textC.Visible = False
textD.Visible = False
textE.Visible = True
textE.Visible = True
Else
textC.Visible = False
textD.Visible = False
textE.Visible = False
textE.Visible = False
End If
 
Back
Top