View Single Post
  #2  
Old May 28th, 2010, 01:36 AM posted to microsoft.public.access.queries
DontKnow
external usenet poster
 
Posts: 47
Default Change colour of a field

Hi Daryl,

Thanks for your responce but Ihave to ask how do you do conditional
formatting??

Is there code you need to develop to set the colours for opartciulars
values... how do you do it??

many thanks for your input!!
Cheers,

"Daryl S" wrote:

DontKnow -

You can use Conditional Formatting on the field. You are limited in the
number of options you have, but it can do what you want.

--
Daryl S


"DontKnow" wrote:

Hi Guys,

Are you able to change the colour of a field dependant on the fields current
value in datasheet view. When the output from a query is opened, I want to
be able to have differeent colours for different values.
Ie when the value in a field is hertz I want the datsheet view to be green,
yet when the value is Custom Fleet I want the colour to be Green...

Am I able to do this from the Datasheet view (output from a query)??

many thanks in advance ??

Cheers,