Hi,
I know how to do confitional formating in Excel by clicking the wizard. Is
this possible in MS Access ? If so, please directly where to look. I found
example but nothing as to how to do it. I am very green in this. Please
help. 3 2089
On Thu, 18 Jan 2007 20:40:36 -0000, Smiley wrote:
Hi,
I know how to do confitional formating in Excel by clicking the wizard. Is
this possible in MS Access ? If so, please directly where to look. I found
example but nothing as to how to do it. I am very green in this. Please
help.
In Access 2000 or newer....
In Form or Report Design View, click on the control you wish to
conditionally format.
Then click on Format + Conditional Formatting.
Follow the dialog.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Morning Fred,
Thank you. I would do the conditional format base on the value of a box. For
example 1 will turn the background to red, 2 turn to green etc.
Is there any way I would do the formating for the whole record, instead of
just a field, in a continuous form ?
Many thanks,
Rach
"fredg" <fg******@example.invalidwrote in message
news:1i******************************@40tude.net.. .
On Thu, 18 Jan 2007 20:40:36 -0000, Smiley wrote:
>Hi,
I know how to do confitional formating in Excel by clicking the wizard. Is this possible in MS Access ? If so, please directly where to look. I found example but nothing as to how to do it. I am very green in this. Please help.
In Access 2000 or newer....
In Form or Report Design View, click on the control you wish to
conditionally format.
Then click on Format + Conditional Formatting.
Follow the dialog.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
On Fri, 19 Jan 2007 09:52:28 -0000, Smiley wrote:
Morning Fred,
Thank you. I would do the conditional format base on the value of a box. For
example 1 will turn the background to red, 2 turn to green etc.
Is there any way I would do the formating for the whole record, instead of
just a field, in a continuous form ?
Many thanks,
Rach
"fredg" <fg******@example.invalidwrote in message
news:1i******************************@40tude.net.. .
>On Thu, 18 Jan 2007 20:40:36 -0000, Smiley wrote:
>>Hi,
I know how to do confitional formating in Excel by clicking the wizard. Is this possible in MS Access ? If so, please directly where to look. I found example but nothing as to how to do it. I am very green in this. Please help.
In Access 2000 or newer.... In Form or Report Design View, click on the control you wish to conditionally format. Then click on Format + Conditional Formatting. Follow the dialog.
-- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
See http://www.lebans.com/conditionalformatting.htm
--
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: Benjamin Niemann |
last post by:
Hello,
I've been just investigating IE conditional comments - hiding things from
non-IE/Win browsers is easy, but I wanted to know, if it's possible to hide
code from IE/Win browsers.
I found...
|
by: jeffgeorge |
last post by:
Trying to add 3 colors to 6 combinations of text possibilities. If
this makes sense, the possibilities are:
A D (one color for the combo beginning with A)
A E
B D (One color for the combo...
|
by: rudy |
last post by:
I am trying to highlight the output of a field to display something
similar to conditional formating. Would prefer to display the result
with a code instead of a colored font or colored background...
|
by: Tom |
last post by:
Is there any way to use conditional formating to change a control for a
field in a continuous form to a textbox, option group or combobox depending
on the value of another field on the form? On a...
|
by: Martin Evans |
last post by:
Sorry, yet another REGEX question. I've been struggling with trying to get
a regular expression to do the following example in Python:
Search and replace all instances of "sleeping" with "dead"....
|
by: slinky |
last post by:
Thanks in advance... I have a continuous style form with a field for
each record called "STATUS". I simply want to have the form load and
if the value of the textbox is "Inactive" I want the...
|
by: Fonix |
last post by:
I'm trying to make table border with pyExcelerator.
As i can see there is only cell formating!? If i'm wrong pls tell me what is method to make more then one cell to have same format, other then...
|
by: sitko |
last post by:
Hi,
I'm in the process of converting a VB.net program into a C program so it can run on a unix like machine.
I've been moving along at a nice pace, but this conversion has stumped me.
I need...
|
by: Earl Anderson |
last post by:
A business colleague and I are collaborating 'long distance' on an applet
for work. He is doing the programming and I am doing the business process
form design. We had discussed my desire to make...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |