Conditional Formatting Colour if No Data

[access2010]

Hello, could I have assistance, of having the colour background in a MsAccess 2003 database change colour on the two conditions below?

A = if the field is empty / Null / Blank / or contains no value = background colour will be Red

B = if the field contains any value = background colour will be Green

Your assistance will be appreciated.

Thank you
Crystal

 

[theDBguy]

Hi Crystal. You could try:
A:Red

Expression Is [FieldName] & "" = ""

B:Green

Expression Is [FieldName] & "" <> ""

Hope it helps...


PS. Actually, if we're talking about the same field here, then you just need to format the control to have a green background and only use the first Conditional Formatting to turn it red, if it's empty.

 

[access2010]

theDBguy
Thank you for your suggestion, but I can not get the colour background to change for the field [ TransactionComm ] if it contains Nothing / Blank

If you have an opportunity could you adjust the code in the attached database for me?
Thank you,
Crystal

 

[theDBguy]

Hi Crystal. Just saw your post but it’s bed time here now, so if it’s okay with you, I’ll take a look in the morning.

 

[Gasman]

Could not see any attempt to change it?

Please see attached, although it does change the new record to red under your conditions.

HTH

 

[Gasman]

This version only shows Red if the ID of the record is populated, ie not a New Record.

HTH

 

[access2010]

Gasman
P.E.R.F.E.C.T

Thank you to both of you for your assistance.
Crystal