Solved

Is Access 2003 Conditional Formatting broken in Windows 8?

Posted on 2013-01-11
13
763 Views
Last Modified: 2013-01-17
I have always used conditional formatting to color the background of an active row in a continuous form using Access 2003 and Windows 7.  However, I find that in Windows 8 conditional formatting doesn't appear to work other than when the form first opens.  Any real time changes don't seem to happen.

Here's the code I am using:

This runs OnCurrent:
   
'Set Record Selector: 'Form has an unbound field ctlCurrentRecord
    If fTestForControl(frmForm, "ctlCurrentRecord") Then
        ![ctlCurrentRecord] = frmForm.SelTop
        If IsNull(![ID]) Then
        Else
            ![ID].Tag = ![ID].Value    'set ID.Tag
        End If
    End If

Open in new window

And my conditional formatting is set to:

Expression Is: [ID].Tag=[ID]

Open in new window

In the past this has always changed the backcolor of the control "Rowcolor" to a different color for the active record.  In Windows 8 it appears to change it when the form first opens but selecting a new record does not update the color as it did in Windows 7 - the first row remains colored.

Anyone know what is happening here and how I can fix it?

Thanks in advance.
0
Comment
Question by:MitchellVII
  • 4
  • 4
  • 3
  • +1
13 Comments
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
I haven't actually tried conditional formatting in an Office 2003/Windows 8 setup.

HOWEVER, Windows 8 and Office 2003 are considered to be incompatible... so while some things may work, you are really stretching your luck if you don't follow the recommendations to upgrade to a newer version of Office.
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
<<HOWEVER, Windows 8 and Office 2003 are considered to be incompatible...>>

Huh...why is that?

Jim.
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
Jim,

Unless I'm completely misunderstanding it (again, I have not tested it myself):
http://support.microsoft.com/kb/2777626

MS is using pretty strong language here:


"If you have a Microsoft Office 2003 suite or application on your PC, you will have problems running it on Windows 8. We recommend you upgrade Office to a newer version that is compatible with Windows 8."
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
<<http://support.microsoft.com/kb/2777626>>

 Typical Microsoft strong arm tactics.   "This won't work", yet they offer nothing of detail as to why.

 And yet Windows 8 includes the desktop specifically so "legacy apps" (non-Metro - oops Metro's out already) can run.

 I don't know of anyone using Access 2000/2003 under Windows 2008 either though, so I can't say the article is off base.

  Their really trying to push Office 2003 out the door....got an e-mail a few weeks ago stating that starting next year, Office 365 will no longer offer POP3 support and there fore will not support Outlook 2003.  

 There's no reason for that.  Even if they wanted to eliminate POP3 (and they'll have a tough time with that), they could have done what they did in the past, which is write a connector to talk to Office 365 (there was a connector for Office Live).

 I love it.  Instead of giving people what they want, they give them what they think they should have and then force them into using it no matter what.

 I do understand not being able to support old software forever, and there may be something fundamental that does make it incompatible, but this seems long a strong arm tactic to me.

 Thanks for the link to the article.

Jim.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
<<HOWEVER, Windows 8 and Office 2003 are considered to be incompatible...>>

Not surprising, given that Office 2003 extended support ends in April 2014 :)
0
 
LVL 5

Author Comment

by:MitchellVII
Comment Utility
Guys, we are turning my question into a discussion of Access 2003 / Windows 8 compatibility.

I am most interested at this point in figuring out what is wrong with conditional formatting.  Seems odd to me that with most things working just fine in Access 2003, this one thing would be broken.

I personally REFUSE to upgrade from Access 2003.  It was the last year they actually got it RIGHT.  Ribbons SUCK.  Navigation Pane SUCKS.  Office 2007 and above is a classic example of MS breaking things that work just fine and ignoring things that are broken.
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 61

Expert Comment

by:mbizup
Comment Utility
<< I am most interested at this point in figuring out what is wrong with conditional formatting>>
Ok - I'll drop out at this point...

You might get other responses, but the real answer very well may be that this and other things are compatibility issues that cannot be fixed.
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
<<Guys, we are turning my question into a discussion of Access 2003 / Windows 8 compatibility.>>

 Sorry we got a bit side-tracked, but it is germain to the point.  It may not flat out work.

<<I am most interested at this point in figuring out what is wrong with conditional formatting.  Seems odd to me that with most things working just fine in Access 2003, this one thing would be broken.>>

 Does to me to, but then how Windows works has been fundamentally changed.

 I would suggest taking a copy of the DB off the windows 8 machine and try it on another non-windows 8 machine.

  If it works, then it's the Office install under Windows 8.  If it doesn't work, then it's the DB.

  If DB, I would create a new DB and import all objects into it.

  If Office, then I'd run a repair and see if that fixes it.  If not, then it may be a fundamental incompatibility with windows 8

<<I personally REFUSE to upgrade from Access 2003.  It was the last year they actually got it RIGHT.  Ribbons SUCK.  Navigation Pane SUCKS.  Office 2007 and above is a classic example of MS breaking things that work just fine and ignoring things that are broken. >>

  I'm on the same page<g>.  You could scrape by in Access 2007 and 2010 with an old DB (command bars and ULS were supported as long as you did not covert the DB to the new ACE format), but now with Access 2013, you can no longer do that as command bars have been dropped.  So with A2013, it is the ribbon and nothing else.

Jim.
0
 
LVL 5

Author Comment

by:MitchellVII
Comment Utility
Jim,

Yes, it seems that MS made a choice after 2003 to design for 5 year olds with lots of pretty pictures as opposed to true functionality that adults could enjoy.

Have you ever noticed that every time MS "upgrades" their products, everything takes MORE steps and is HARDER to use?

Can you recommend a good simple method for coloring active rows in Windows 8?

* I've also noticed that Windows 8 doesn't care for calculated values in unbound controls but it doesn't mind if you put the calculation in the underlying query and bind it to the field.  Weird.
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
Comment Utility
<<Can you recommend a good simple method for coloring active rows in Windows 8?>>

 You can revert to the old method, which doesn't rely on condition formatting.  What you do is put a control behind the other controls, set the background on your controls to tranparent, and then fill the background control with a color or graphic.

 I've attached a sample of that.

<<* I've also noticed that Windows 8 doesn't care for calculated values in unbound controls but it doesn't mind if you put the calculation in the underlying query and bind it to the field.  Weird.>>
 
  Hum...can't think of why that would be.

Jim.
ContinuousFormColors.MDB
0
 
LVL 5

Accepted Solution

by:
MitchellVII earned 0 total points
Comment Utility
Ok, THIS is weird. Conditional formatting just started working again!

Have NO idea what I changed but it is working fine now.  Bizarre.  So apparently conditional formatting for Access 2003 DOES still work under Windows 8.

Will distribute points as best I can.
0
 
LVL 5

Author Closing Comment

by:MitchellVII
Comment Utility
Just started working all of a sudden.  Thanks everyone.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now