![]() |
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
|
|||
|
|||
![]()
I have a form which includes several fields with conditional formats. the
format is determined by the user ticking a yes/no box included in both the Table and the Query from which the form is created. when i open the Form the previously saved format is displayed but the user cannot turn off the format with the yes/no box. However if i open the underlying query in design view and the close it the form works ok. Any help appreciated. |
#2
|
|||
|
|||
![]()
Aussiebob -
Chances are you don't have code behind all the events you need and/or the code is not complete. For example, you may have code in the OnCurrent event of a form, which test and format the form as you scroll through new records, but it would not help if the user changed a value on a current record. If there are a lot of events that should trigger this code, then the code should be in a form procedure that you can call from each event that could affect the formatting. Also, you may have code that is 'half' there, such as an if statement with a conditional formatting but no else clause to set the formatting back to normal. If you want more help, post your code, and include when/how it is called. -- Daryl S "aussiebob" wrote: I have a form which includes several fields with conditional formats. the format is determined by the user ticking a yes/no box included in both the Table and the Query from which the form is created. when i open the Form the previously saved format is displayed but the user cannot turn off the format with the yes/no box. However if i open the underlying query in design view and the close it the form works ok. Any help appreciated. |
Thread Tools | |
Display Modes | |
|
|