Solved

Is Access 2003 Conditional Formatting broken in Windows 8?

Posted on 2013-01-11
13
766 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
ID: 38766698
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
ID: 38766736
<<HOWEVER, Windows 8 and Office 2003 are considered to be incompatible...>>

Huh...why is that?

Jim.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 38766787
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 57
ID: 38766857
<<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
ID: 38766954
<<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
ID: 38766956
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
 
LVL 61

Expert Comment

by:mbizup
ID: 38766979
<< 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
ID: 38767083
<<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
ID: 38767205
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
ID: 38767510
<<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
ID: 38770254
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
ID: 38786389
Just started working all of a sudden.  Thanks everyone.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

838 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