Prev: How to make detail section expand/contract relative to number of l
Next: Final Reminder - Microsoft Responds to the Evolution of Community
From: SnooziSuzi on 28 May 2010 09:44
Hi, I am also having this problem and have followed the steps above but it
is still not displaying a shaded field on my report.

I have highlighted the field, clicked conditional formatting, dropped down
to 'Expression is' typed "JobTitle" is null, set the outcome (ie a shaded
feild) but when I run the report the blank fields are still empty!! (have
also tried with the square brackets in, in case that was my problem).

I have checked that they are set to Can Grow 'NO' and that the font colour
is black so that it would show up....

what else can I do!?

I am using Access 2007.

Thanks very much,
--
Snoozi Suzi


"jmuirman" wrote:

> Ahhh...Thanks! I forgot the field name.
> "Allen Browne" wrote:
>
> > Try:
> > Expression [MyField] Is Null
> > replacing "MyField" with the name of your control.
> >
> > --
> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > Tips for Access users - http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
> >
> > "jmuirman" <jmuirman(a)discussions.microsoft.com> wrote in message
> > news:09873DA9-6002-4170-9973-E762087FB797(a)microsoft.com...
> > >I want to have a field in a report become red if the field is blank. I
> > >can't
> > > seem to use conditional formatting for this.
> > >
> > > Thanks,
> > >
> > > John
> >
> >
> >
 | 
Pages: 1
Prev: How to make detail section expand/contract relative to number of l
Next: Final Reminder - Microsoft Responds to the Evolution of Community