A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Conditional Formatting Question - blank field



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2006, 04:12 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Conditional Formatting Question - blank field

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
  #2  
Old May 24th, 2006, 04:36 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Conditional Formatting Question - blank field

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" wrote in message
...
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



  #3  
Old May 24th, 2006, 04:39 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Conditional Formatting Question - blank field

What are you putting in the boxes in the conditional formatter?
It probably is just a syntax problem.

"jmuirman" wrote:

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

  #4  
Old May 24th, 2006, 05:00 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Conditional Formatting Question - blank field

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" wrote in message
...
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




  #5  
Old May 28th, 2010, 02:44 PM posted to microsoft.public.access.reports
SnooziSuzi
external usenet poster
 
Posts: 8
Default Conditional Formatting Question - blank field

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" wrote in message
...
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




 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tough conditional formatting question jezzica85 General Discussion 8 April 8th, 2006 01:38 AM
DCount compare table.textfield to form.text field question RNUSZ@OKDPS Using Forms 1 March 11th, 2005 03:05 AM
Prevent Blank Records being written. Need Help. Robert Nusz @ DPS Using Forms 4 December 29th, 2004 06:15 PM
Excel Conditional Formatting and Blank Cells bxb7668 General Discussions 3 November 9th, 2004 07:06 PM
Required Field Conditional Katherine R New Users 2 September 1st, 2004 05:52 AM


All times are GMT +1. The time now is 11:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.