Hello
With MSAccess 2000, I have created a program with forms and applied
some Conditional Formatting on some of the text box.
This program is being used on a network and every few seconds the program
checks the
backend database to see if other users have made any changes to the data and
if so
updates the screen to show these updates.
However, when some forms that have Conditional Formatting are updated with
the new data,
the forms do not always apply the Conditional Formatting.
Example: If a continuous form has some records highlighted in color because
of some
Conditional Formatting, when the form is updated with new data, sometimes
all the Conditional
Formatting colors disappear. (The form is bound to a table and the part of
the program
that checks the backend for updates simply reloads the table with the new
data and requeries the form)
I have tried to Requery, Refresh, and Repaint the form but nothing works.
Is there a command to force Conditional Formatting to be applied?
Thanks
G.Gerard
With MSAccess 2000, I have created a program with forms and applied
some Conditional Formatting on some of the text box.
This program is being used on a network and every few seconds the program
checks the
backend database to see if other users have made any changes to the data and
if so
updates the screen to show these updates.
However, when some forms that have Conditional Formatting are updated with
the new data,
the forms do not always apply the Conditional Formatting.
Example: If a continuous form has some records highlighted in color because
of some
Conditional Formatting, when the form is updated with new data, sometimes
all the Conditional
Formatting colors disappear. (The form is bound to a table and the part of
the program
that checks the backend for updates simply reloads the table with the new
data and requeries the form)
I have tried to Requery, Refresh, and Repaint the form but nothing works.
Is there a command to force Conditional Formatting to be applied?
Thanks
G.Gerard