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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 02:05 AM |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Excel Conditional Formatting and Blank Cells | bxb7668 | General Discussions | 3 | November 9th, 2004 06:06 PM |
Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |