Solved

Access Conditional formatting not working

Posted on 2015-01-25
9
128 Views
Last Modified: 2015-01-29
Hi Experts,

I have the attached formatting conditions set to one of the controls of my continuous forms, and for some odd reason its not showing, when I do this for the control itself that's bound to the field used in condition it works, however I need it in another control that formats the original value (minutes) into hh:mm.
untitled.bmp
0
Comment
Question by:bfuchs
9 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40570015
I need it in another control that formats the original value (minutes) into hh:mm.
This works fine for me...

Can you post a sample db that exhibits this behavior?
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 350 total points
ID: 40570260
however I need it in another control that formats the original value (minutes) into hh:mm.
Where is the formatting done? Since this is a Continuous form, I'd assume it's being done in the query.

Conditional formatting is finicky in many regards. From what I can tell, you're trying to set a condition if the value of "minschedthisweek" is less than 1800 or between 1800 and 2399. If so, what datatype is "minschedthisweek", and where does that data come from? If you've formatted the column from which it is derived (i.e. in the query) then you may find your conditional formats refer to the wrong field.

Do you have a field that shows the "raw" minutes, which aren't formatted? If not, you might consider adding one, and then changing your formats to refer to that field instead.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40570267
Also, if your MinSchedThisWeek value uses the NZ( ) function inside a query, you may be expecting to see a numeric value, but when used in a query, the NZ() function will return a string, so you must explicitly convert that string to a number:

MinSchedThisWeek: cLng(NZ(X, 0))
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 4

Author Comment

by:bfuchs
ID: 40571292
Hi Experts,

I finally boiled down this issue to be version related, as its only happening on office 2k (the version I am forced to use for programming, while there're still some users with that version..)

While that at least answers your questions, why is it working by you and proves the field is named correctly and its a number type etc...however these still does not help me, as I need it to work in 2000 as well...

Thanks,
Ben
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 150 total points
ID: 40571587
Ben,

You know, its funny.
While programming in the lowest user version of Access is certainly the best way to go....
But this presumes that you are only going back a reasonable amount of versions...
;-)

Asking a 14 year old version of Access to be 100% compatible with more current versions is a stretch.
I feel your pain, ...but this may not be the only compatibility issue you have to deal with.
;-)

Check back in with Scott,... his theory sound like it should work for you.

JeffCoachman
0
 
LVL 4

Author Closing Comment

by:bfuchs
ID: 40571900
The solution was to have that formatting done in query instead of the form itself.
thanks for Scott for hinting me of that
and thanks for Jeff for pointing me back to Scott..
0
 
LVL 4

Author Comment

by:bfuchs
ID: 40571919
BTW,
You know, its funny.
Its not funny at all, our manager does not want to approve upgrading to a new version unless I can prove that overall performance will increase significantly..
Unfortunately I only found it to be the opposite when compared to newer versions.
In addition to the fact that part of our app is an ADP that Microsoft abandoned in recent version..
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 40577828
The longer your manager waits to upgrade, the more painful it will be.  I recently had the dubious pleasure of updating a number of databases for a client.  Some of them were in Access 95 format.  I had to make an Access 97 VM just so I could open them and resave them as Access 97 databases, then open those databases in an Access 2003 VM, save them in that format, and finally open the 2003 dbs in Access 2010, and upgrade them to that format.  Not everything survived the multiple format transitions.
0
 
LVL 4

Author Comment

by:bfuchs
ID: 40578960
@Helen_Feddema,
The reason our manager is hesitating of an upgrade is as follows.
We have an app that was orig written in 97, and eventually successful converted to 2000, since then we purchased a few licenses of 2003, and parts of our app are performing slower for those users (although each user has their own copy, and app was converted for them to 2003..).

Therefore you're right that when we are finally going to convert it will be harder, but he claims that its not worth to suffer in terms of performance until MSFT will finally come out with a product that addresses those issues...
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

803 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