Conditional Formatting Issue

[Pete]

I have a form that list a series of records. One of the fields is
formatted with the Conditional Formatting option.

When the form is opened, the data list is present. However, only the
first record has the formatting (Colored background). The other
records display as if there was not formatting applied. However, when
I move the mouse over the list, all of the records show the formatting.
If I stop moving the mouse, the formatting display stops. It appears
to be related somehow to the focus on the individual record.

Has anyone seen this and is there a way to cause the formatting to
display when the records are displayed? I need to see ALL of the
formatting for the entire list of records on the form.

 

[Wayne Morgan]

It sounds as if the form is in continuous form view. Did you use the
conditional formatting option on the control with the form open in design
view?

Just moving the mouse over the records shouldn't have that effect since
you're not actually moving the record cursor when you do that. So, it
appears to be a display problem, not a logic or data problem. If that's the
case, the first thing I would try would be to make sure that the video
driver is the most current one and that the Office patches are up to date.
For the video driver, see the video card manufacturer's web site or the
computer manufacturer's web site to see if they have a newer one. For the
Office patches, go to

http://office.microsoft.com/en-us/officeupdate/default.aspx

and click on "Check for updates".

Another option on the video, open the display properties in Control Panel,
go to the Settings tab and click the Advanced button. Next, go to the
Troubleshoot tab and make sure "Hardware acceleration" is set to Full.

 

[Pete]

It is not a display problem. The issue only occurs when the
application is run using access 2000. It runs pefectly under XP or
2003.

I am beginnng think it is a bug. When the contion occurs, I see
CALCULATING in satus area.

I have on field that calls a routine to set a variable used by the
conditinal formatting. The routine simply returns a True or False,
depending on what was last used.

 

[Wayne Morgan]

If the same file runs fine under Access XP or 2003, I'll agree it sounds
like a bug. That was the reason for asking if you had all of the Office
patches installed. Also, was this file developed under XP or 2003 then
opened on 2000? If so and you used a command that 2000 doesn't recognize, it
may cause a problem. The file format will be in the 2000 file format so
Access 2000 can open it, but the newer versions also have commands that
didn't exist in Access 2000 and those won't work.

In addition to the Office updates, make sure that you have Jet and MDAC up
to date. You can find these updates here:

http://msdn.microsoft.com/data/downloads/updates/default.aspx

If you're running WinXP or Win2k, you can also get the Jet updates by going
to

http://update.microsoft.com