473,568 Members | 2,755 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2007 - conditional formatting - beware

A comment and a question

To anyone who is using conditional formatting, beware that in Access
2007 the color pallette is not the same as the color pallette in Access
2003. So if you have a particular color you were using as a standard
throughout your application, the only way to continue using that color
is to code the color.

Anyone else notice how forms in Access 2007 display the conditional
formatting much slower than in Access 2003? (I have one particular
form so far in my Access 2007 testing that only shows the conditional
formatting wherever the mouse cursor is currently residing.)

ds

Dec 1 '06 #1
1 4215
The RGB color values in Access 2007 are displayed in Hex format, which is a
fairly widely used standard, e.g. web developers are familiar with this. But
the color values are essentially the same as in previous versions.

The old color values consist of a long integer that is generated by
combining the Red, Green, and Blue bytes. The RGB function did that, e.g.:
RGB(btRed, btGreen, btBlue)
The A2007 version shows the same long integer in hex format, e.g. Hex(btRed)

A2007 also defines a few special values for system colors. Older versions of
Access had these special values also, but they were not published.

Programmaticall y, you can modify the ForeColor and BackColor of the
FormatCondition to any value you like.

Hope that opens a few doors for you.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<dd**********@g mail.comwrote in message
news:11******** **************@ l12g2000cwl.goo glegroups.com.. .
>A comment and a question

To anyone who is using conditional formatting, beware that in Access
2007 the color pallette is not the same as the color pallette in Access
2003. So if you have a particular color you were using as a standard
throughout your application, the only way to continue using that color
is to code the color.

Anyone else notice how forms in Access 2007 display the conditional
formatting much slower than in Access 2003? (I have one particular
form so far in my Access 2007 testing that only shows the conditional
formatting wherever the mouse cursor is currently residing.)

Dec 2 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5921
by: Jouke Langhout | last post by:
Hello all! For quite some time now, I've got the following problem: Access won't close properly when a user closes the application. An ACCESS process stays active and that process can only be terminated by pressing ++ and then terminate the process. I searched the entire internet and found out that there could be two things wrong (both...
5
3069
by: Richard | last post by:
Hi, I have a form that take some time to load due to many comboboxes and at least 8 subforms. When I filter or sort the main form I get an error message and then Access shuts down. They ask if I want to send the error report to Microsoft. Has anybody seen this type of error message and what can I do to prevent it from happening. Am I doing...
4
6870
by: brAccess | last post by:
I recently installed Access 2003 and immediately noticed problems with applications that work fine in 2000 and XP. I use conditional formatting on continuous forms for a number of reasons. When these forms are opened in 2003, Access seems to go into a continuous loop. Has anyone else experienced this problem? Does anyone know of a solution...
4
2122
by: Wayne Aprato | last post by:
I have a simple database which was originally written in Access 97. When converted to Access 2000 file format it ran flawlessly in Access 2002. I've just tried to run it in Access 2003 and I am seeing the following behaviour: Some of the fields on the continuous main form which is a list of jobs with their related details "flicker". While...
4
3124
by: Bradley | last post by:
I have an A2000 database in which I have a continuous form with a tick box. There is also a text box with a conditional format that is based on the expression , if it's true then change the background colour. In A2000 it works great, but in A2003 the background doesn't always change and when it does it only changes when the record looses...
5
8951
by: Andrew Chanter | last post by:
Does anyone know a way you can use conditional formatting to create a banded style view as is commonly seen on the internet. (In othe words the first record appears on a gray background, the 2nd on white, the third on gray etc etc.) I could write an expression based on the odd/even status of the primary key but this wont work when sorting...
6
3640
by: GAC | last post by:
I've used conditional formatting on ACCESS reports but have come up with a problem using it for a FIELD that has a value of either YES or blank/null. The default formatting (used when condition(s) are not met) is always used EVEN WHEN I specify Condition 1 to change the formatting when the field is YES. What am I missing....doesn't...
4
6470
by: TD | last post by:
I am trying to change the forecolor of a field in a subform that is in datasheet view. I am using Access 2007. I have tried everything I can think of to do this but the text still appears in black. I need it to appear in red if the field has the word "YES" in it. Is there something in Access 2007 that keeps this from working?????
4
5629
by: riaane | last post by:
Please help: I have Conditional Formatting on a Report Field that fills the background Red if the criteria is met. This displays correctly in Report View, however, when I "OutputTo" this report to "Rich Text Format (*.rtf)", the colour is lost on the resultant RTF document when I open it up in Word 2007. I would obviously like to retain the...
0
7693
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7604
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8117
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6275
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5498
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5217
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3631
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
932
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.