By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Conditional formating

P: n/a
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.
Jan 18 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Jan 18 '07 #2

P: n/a
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

Jan 19 '07 #3

P: n/a
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
Jan 19 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.