Prev: Translate if statement in query
Next: Access 2003 + a few other questions
From: DontKnow on 27 May 2010 17:38
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,
From: DontKnow on 27 May 2010 20:36
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,
From: John W. Vinson on 27 May 2010 21:20
On Thu, 27 May 2010 17:36:01 -0700, DontKnow
<DontKnow(a)discussions.microsoft.com> wrote:

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

Open the Form in design view.

Select "Format" from the menu.

Select "Conditional Formatting" from the options presented.
--

John W. Vinson [MVP]
From: DontKnow on 27 May 2010 23:12
Hi John,

Its not a form that I require help, its the output from a QBE which is only
a datasheet view, can you do conditional formatting from the output from a
query? I don't think that you can.

I have no problems in conditional formatting whilst the output is in a form,
but the output from a query (datasheet view) I am not sure if this is even
possible?

many thnaks for input!!

Cheers,

"John W. Vinson" wrote:

> On Thu, 27 May 2010 17:36:01 -0700, DontKnow
> <DontKnow(a)discussions.microsoft.com> wrote:
>
> >Thanks for your responce but Ihave to ask how do you do conditional
> >formatting??
> >
>
> Open the Form in design view.
>
> Select "Format" from the menu.
>
> Select "Conditional Formatting" from the options presented.
> --
>
> John W. Vinson [MVP]
> .
>
From: John W. Vinson on 28 May 2010 00:59
On Thu, 27 May 2010 20:12:01 -0700, DontKnow
<DontKnow(a)discussions.microsoft.com> wrote:

>Hi John,
>
>Its not a form that I require help, its the output from a QBE which is only
>a datasheet view, can you do conditional formatting from the output from a
>query? I don't think that you can.
>
>I have no problems in conditional formatting whilst the output is in a form,
>but the output from a query (datasheet view) I am not sure if this is even
>possible?

This is one of a great many reasons to routinely use Forms for all output, and
not allow users to even know that query/table datasheets *exist*.
--

John W. Vinson [MVP]
 |  Next  |  Last
Pages: 1 2
Prev: Translate if statement in query
Next: Access 2003 + a few other questions