Prev: Translate if statement in query
Next: Access 2003 + a few other questions
From: Daryl S on 28 May 2010 11:29
You should do this in a form, then you can use the datasheet view of the
form...

--
Daryl S


"DontKnow" 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?
>
> 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: DontKnow on 30 May 2010 04:47
Many thanks guys (John qnd dARYL), just confirms what I had thought,,

Cheers,

"Daryl S" wrote:

> You should do this in a form, then you can use the datasheet view of the
> form...
>
> --
> Daryl S
>
>
> "DontKnow" 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?
> >
> > 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]
> > > .
> > >
First  |  Prev  | 
Pages: 1 2
Prev: Translate if statement in query
Next: Access 2003 + a few other questions