PC Review


Reply
Thread Tools Rate Thread

code to set background colors

 
 
=?Utf-8?B?bWF1a2Vu?=
Guest
Posts: n/a
 
      21st Jan 2007
access 2002.
I view a datasheet and would like all fields where field a is greater than
field b to have red background and another field where name = female to have
blue blackground.
--
regards, maurice.
 
Reply With Quote
 
 
 
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      21st Jan 2007
"mauken" <(E-Mail Removed)> wrote in message
news:A6812959-99D1-4BB1-B0A5-(E-Mail Removed)...
> access 2002.
> I view a datasheet and would like all fields where field a is greater
> than
> field b to have red background and another field where name = female to
> have
> blue blackground.


In the form's Design View, select a the control, choose Format >>>
Conditional Formatting and set your conditions.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


 
Reply With Quote
 
=?Utf-8?B?bWF1a2Vu?=
Guest
Posts: n/a
 
      22nd Jan 2007

--
regards, maurice.


"Arvin Meyer [MVP]" wrote:

> "mauken" <(E-Mail Removed)> wrote in message
> news:A6812959-99D1-4BB1-B0A5-(E-Mail Removed)...
> > access 2002.
> > I view a datasheet and would like all fields where field a is greater
> > than
> > field b to have red background and another field where name = female to
> > have
> > blue blackground.

>
> In the form's Design View, select a the control, choose Format >>>
> Conditional Formatting and set your conditions.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> Thanks for your quick response.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP!: VBA code for Datasheet Form for background colors zmenloans Microsoft Access 0 9th Jun 2009 03:51 PM
re: Background colors Mark Bechmann Microsoft Access 0 9th Sep 2008 09:30 PM
Lost highlighting and font colors; background colors on web pages =?Utf-8?B?SmFuIGluIFJhbGVpZ2g=?= Microsoft Excel Misc 2 31st Jul 2007 09:10 PM
Windows Mail Stationery Stopped Working, Also Font colors and background colors... John Hanley Windows Vista Mail 4 5th Jun 2007 01:18 PM
Font colors and Background Colors =?Utf-8?B?RHJhbmtQQTY=?= Microsoft Excel Crashes 2 13th Aug 2005 03:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:23 AM.