conditional format varies by machine

  • Thread starter Thread starter vircalendar via AccessMonster.com
  • Start date Start date
V

vircalendar via AccessMonster.com

I have a small, unsplit Access 2003 DB that runs in a shared environment. It
is accessed by a few users, each of whom is on a different desktop running
Win XP. The main form uses conditional formatting of background colors in
several fields. This works fine on all of the machines but one, which
displays only two of the three conditional colors. When it's supposed to
display the third, it instead shows the default background.

This is obviously something based in the individual machine rather than the
DB, but I can't find the problem. Any ideas about where I should look?
 
Hello "vircalendar".

vircalendar via AccessMonster.com said:
[...]The main form uses conditional formatting of background colors
in several fields. This works fine on all of the machines but one,
which displays only two of the three conditional colors. [...]
Click to expand...

It would be easier to make a suggestion if you posted the condition.
Without knowing the formula, I guess that it relies on the format of
a value depending on the regional settings of the operating system,
so I suggest to compare the "Regional and Language Settings" in
Control Panel on your machines.
 
Back
Top