If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting Doesn't Update
--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??? |
#2
|
|||
|
|||
Conditional Formatting Doesn't Update
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 BCS wrote: --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??? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
error message apears | keen but dumb | General Discussion | 3 | October 7th, 2005 11:20 AM |
conditional formatting in form slows down calculations | Susan | Using Forms | 5 | June 13th, 2005 11:24 AM |
difficulty with conditional formatting | Deb | General Discussion | 0 | March 23rd, 2005 06:13 PM |
Too much conditional formatting? | LJpse | General Discussion | 1 | November 8th, 2004 01:50 AM |
Freezing Conditional Formatting | Ashish Chamaria | Worksheet Functions | 3 | December 19th, 2003 10:54 AM |