Hi,
I am trying to add some visual confirmation to a continous form, to let
the user know if a stored date on the form has passed. I have managed
to set the background colour using a simple IF statement comparing the
stored date with the Date() control and the .backcolour vb control.
however once the background colour of the field has been set, it sets
the colour for every line on the form. Is there anyway of making just
specific cells on specific lines turn a different colour?
thanks in advance
Richard
5  2011 
Try conditional format under the format menu.
i can't find any option for Conditional format? where is this located,
in the properties box?
thanks
Richard
Svetlana wrote:
Try conditional format under the format menu.
On 2 Oct 2006 06:31:19 -0700, kaisersose1995 wrote:
i can't find any option for Conditional format? where is this located,
in the properties box?
thanks
Richard
Svetlana wrote:
>Try conditional format under the format menu.
It's not located on the properties box, in on the Format menu.
In Form design view, select the control you wish to conditionally
format.
Then click on the menu Format + Conditional Formatting.
This is only available from Access 2000 and newer.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
ah right, that'll be the reason then, we're still using 97 as the "guys
upstairs" won't give us the budget to upgrade....i guess i'll have to
try another way, thanks anyway though
Rich
fredg wrote:
On 2 Oct 2006 06:31:19 -0700, kaisersose1995 wrote:
i can't find any option for Conditional format? where is this located,
in the properties box?
thanks
Richard
Svetlana wrote:
Try conditional format under the format menu.
It's not located on the properties box, in on the Format menu.
In Form design view, select the control you wish to conditionally
format.
Then click on the menu Format + Conditional Formatting.
This is only available from Access 2000 and newer.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
....in that case, see www.lebans.com ...he has workaround for earlier
versions.
William Hindman
"kaisersose1995 " <ka************ @hotmail.comwro te in message
news:11******** **************@ e3g2000cwe.goog legroups.com...
ah right, that'll be the reason then, we're still using 97 as the "guys
upstairs" won't give us the budget to upgrade....i guess i'll have to
try another way, thanks anyway though
Rich
fredg wrote:
>On 2 Oct 2006 06:31:19 -0700, kaisersose1995 wrote:
i can't find any option for Conditional format? where is this located,
in the properties box?
thanks
Richard
Svetlana wrote:
Try conditional format under the format menu.
It's not located on the properties box, in on the Format menu.
In Form design view, select the control you wish to conditionally
format.
Then click on the menu Format + Conditional Formatting.
This is only available from Access 2000 and newer.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: John D |
last post by:
I am trying to change the background colour of either a div or a textarea
with javascript, but am having problems.
I have passed a hex colour value in the variable hval, and with the
following code can change the background colour of the whole page, but only
(now) want to change either a textarea of a form or a div.
I'm stuck.
document.bgColor = hval;
|
by: Holden Caulfield |
last post by:
Hi there,
for IE 5+ I need to be able to change certain TD tags´ background
colors, and can´t figure out how to do it...
For instance, in a table with 25 cells, somewhere between 5 or 10 will
need the bgcolor to change at the same time when a user clicks a
button. Right now only one changes when I use something like this...
document.getElementById(´cellchange´).style.backgroundColor = "FFFFFF"
** (Note, this is not the EXACT code, I...
|
by: Dj Frenzy |
last post by:
Hi, I know how to use javascript to change a background image to
another background image, and how to change a background colour to
another background colour. Is there a way to change an image to a
backgound colour?
I have a table with a background that has a picture. When the user
hovers over the picture I want the background to change to the
background colour of the rest of the page, as if to make the picture
disappear.
|
by: david.graham18 |
last post by:
Hi
I spotted some nice code to change the background colour of a web page to
one of four different colours at random but I can't find it now!
The method was to select a number at random from 1 to 4 by using the rnd()
function and then dividing by modulus 4. The result was then used to select
a cell in a 4 cell array which was holding a different colour in each cell
of the array. I would like to have this code but lack the knowledge to...
|
by: madsgormlarsen |
last post by:
Hi
I am making a tab menu with css, and the tabs changes color depending
on wich tab is current.
1. I could load a different css file for each tab/color.
2. I could do some inline css only for the color of the tabs. (which I
would then change with trough php).
3. I could make a different class for each color, and change the class
of the tab.
| | |
by: Bill Elgie |
last post by:
In accessXP is it possible to have single cells a different colour
depending upon their data content. In Ac97 and 2000 you can only
change the whole datasheet(lying on a form) to a different colour
which is pretty useless and a bit 1900's There are various grip type
libraries in VB but just wondering if this feature is now built into
AcXP
Regards Bill
|
by: Bundy |
last post by:
Hi
How do I change the background colour of an input box in a form as soon
as the value is changed? Also the background should revert back to it's
original colour if the user decides that they do not want to make any
changes and hence retype back the orginial value.
I do not want the background to change after the user has moved to the
next form field but as soon as the value has been changed.
|
by: Brian Ward |
last post by:
I am looking for a simple way to set the image transparency in a PictureBox.
I have a moving PictureBox containing a graphic image .. moving by
incrementing its Left property.
The background however shows white as the PictureBox moves but I want it
to be transparent.
The PictureBox BackColor is set to Transparent .. but no affect. I have
used PhotoShop to make the image background transparent .. again no
affect.
If I make the image a...
|
by: bettyboo |
last post by:
Hi
I'm new to the forum and also a VERY new user of Access to develop databases. I'm building a DB for a driving instructor acquaintance, and he wants a button on the pupil data entry form which he can click to flag a pupil as "Do Not Rebook" (i.e. if they're a non-payer or something). Upon clicking the button, he wants a value to be recorded in the appropriate field in the table (so we can report on it later) and he also wants the...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
