Conditional Formatting Doesn't Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

--THE SETUP--

I'm creating a database in Access 2003 to enter/compile/organize some data
that I've collected during some recent testing.

There are four images that were captured during each test. Each of the
images was than analyzed for different angles and measurements.

The form that I am trying to create has four individual checkboxes (one for
each image captured) and a set of textboxes for all of the measurements made
for each image (one record in the database equal one complete test).

It "looks" something like this

[Img1Chkbx] [Img2Chkbx] [Img3Chkbx] [Img4Chkbx]
[Meas1_1] [Meas1_2] [Meas1_3] [Meas1_4]
[Meas2_1] [Meas2_2] [Meas2_4]
[Meas3_2]

Currently, using the conditional formatting menu, I have set the default
format of the textboxes ( [MeasX_X] ) to "Not Enabled" and once Condition One
is met (respective checkbox has value of Yes), enable them so that data can
be entered.

--THE ISSUE--

When in form view, once a (any) checkbox is checked, the respective textbox
property is changed (From "Not Enabled" to "Enabled") as desired. But the
textbox does not update visually (even though the textbox is now enabled it's
still "grayed" out).

To get the textboxes to "update" visually, each must be selected
individually(either with a mouse click or a tab stop) AND then the focus must
leave the selected textbox to another control (i.e. simply clicking on the
textbox does not "wake it up"). Switching to a different record and then back
will update all of the textboxes to thier appropriate state.

Going in the other direction, if a checkbox wasn't checked initially (
[ImgXChkbx]= No ) and then it is checked (= Yes) the same thing happens;
textboxes function as desired but do not visually update. Additionally, there
is no way the select and the deselect a control that is "Not Enabled", so it
always looks enabled (unless a different record is selected).

While this conditional formatting is not required, it does make the data
entry process easier to do, as well as improves the readability and
understanding of the form (Besides, it should work!)

I have done the exact same thing in a different database created in Access
2000 and did not have these issues (as soon as the checkbox was updated,
everything else changed). When I open that working database in Access 2003 it
still functions as desired.

What's happening???
 
BCS,

I had something similar happen recently, where I had a lot of
Conditional Formatting happening on a form. I can't remember exactly,
but try putting a line of code like this...
Me.Refresh
.... on the After Update event of each of the comboboxes. I think that
might have been what worked for me.

--
Steve Schapel
Microsoft Access MVP

--THE SETUP--

I'm creating a database in Access 2003 to enter/compile/organize some data
that I've collected during some recent testing.

There are four images that were captured during each test. Each of the
images was than analyzed for different angles and measurements.

The form that I am trying to create has four individual checkboxes (one for
each image captured) and a set of textboxes for all of the measurements made
for each image (one record in the database equal one complete test).

It "looks" something like this

[Img1Chkbx] [Img2Chkbx] [Img3Chkbx] [Img4Chkbx]
[Meas1_1] [Meas1_2] [Meas1_3] [Meas1_4]
[Meas2_1] [Meas2_2] [Meas2_4]
[Meas3_2]

Currently, using the conditional formatting menu, I have set the default
format of the textboxes ( [MeasX_X] ) to "Not Enabled" and once Condition One
is met (respective checkbox has value of Yes), enable them so that data can
be entered.

--THE ISSUE--

When in form view, once a (any) checkbox is checked, the respective textbox
property is changed (From "Not Enabled" to "Enabled") as desired. But the
textbox does not update visually (even though the textbox is now enabled it's
still "grayed" out).

To get the textboxes to "update" visually, each must be selected
individually(either with a mouse click or a tab stop) AND then the focus must
leave the selected textbox to another control (i.e. simply clicking on the
textbox does not "wake it up"). Switching to a different record and then back
will update all of the textboxes to thier appropriate state.

Going in the other direction, if a checkbox wasn't checked initially (
[ImgXChkbx]= No ) and then it is checked (= Yes) the same thing happens;
textboxes function as desired but do not visually update. Additionally, there
is no way the select and the deselect a control that is "Not Enabled", so it
always looks enabled (unless a different record is selected).

While this conditional formatting is not required, it does make the data
entry process easier to do, as well as improves the readability and
understanding of the form (Besides, it should work!)

I have done the exact same thing in a different database created in Access
2000 and did not have these issues (as soon as the checkbox was updated,
everything else changed). When I open that working database in Access 2003 it
still functions as desired.

What's happening???
Click to expand...
 
Back
Top