Formatting Mystery

[Bill]

I have a A2K form wherein one of the text boxes has
conditional formatting applied. However, I cannot
get the conditional formatting to work properly.
Using:

Expression Is (and the expression) [GAP_Perf] > 0

I intend that the text box content be displayed in
red if the database DATE field, [GAP_Perf], contains
a date value.

I've also tried the expression [GAP_Perf] <> "",
but that didn't produce any change either.

What am I missing?

Thanks,
Bill

 

[Allen Browne]

Test if the date field is Null:
Expression ... [GAP_Perf] Is Null
or perhaps:
Expression ... IsNull([GAP_Perf])

A Null is not the same thing as a zero-length string. For more info, see:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

 

[Bill]

Allen,
I'm really in mystery about this one. Neither of the
two expressions you suggested worked.

Probably only about 5 or 6 percent of the GAP_Perf
fields have values (short date). So, using IsNull should
have shown a flood of red.

Bill

Test if the date field is Null:
Expression ... [GAP_Perf] Is Null
or perhaps:
Expression ... IsNull([GAP_Perf])

A Null is not the same thing as a zero-length string. For more info, see:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a A2K form wherein one of the text boxes has
conditional formatting applied. However, I cannot
get the conditional formatting to work properly.
Using:

Expression Is (and the expression) [GAP_Perf] > 0

I intend that the text box content be displayed in
red if the database DATE field, [GAP_Perf], contains
a date value.

I've also tried the expression [GAP_Perf] <> "",
but that didn't produce any change either.

 

[Rob Oldfield]

If you create a query based on the table, add GAP_Perf and
isnull([GAP_Perf]) you should see true/false values. Does that work?

Allen,
I'm really in mystery about this one. Neither of the
two expressions you suggested worked.

Probably only about 5 or 6 percent of the GAP_Perf
fields have values (short date). So, using IsNull should
have shown a flood of red.

Bill

Test if the date field is Null:
Expression ... [GAP_Perf] Is Null
or perhaps:
Expression ... IsNull([GAP_Perf])

A Null is not the same thing as a zero-length string. For more info, see:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a A2K form wherein one of the text boxes has
conditional formatting applied. However, I cannot
get the conditional formatting to work properly.
Using:

Expression Is (and the expression) [GAP_Perf] > 0

I intend that the text box content be displayed in
red if the database DATE field, [GAP_Perf], contains
a date value.

I've also tried the expression [GAP_Perf] <> "",
but that didn't produce any change either.

 

[Bill]

Problem solved!

I had this problem about 3 years ago and had forgotten
one of my own rules: "DO NOT NAME A TEXT BOX
USING THE SAME NAME AS THE CONTROL
SOURCE", as Access gets confused.

Thanks for all the thoughts and suggestions.
Bill