Color Selecting Records

[McObraz]

Hello.

I am having some trouble trying to color select a record based on when a particular field has any data. Basically, I have a continuous form (datasheet) which has fields such as FirstName, LastName, and the like. One of those fields is Notes. What I wish to happen is that if there is any data in the Notes field, the whole record should be selected with a different color background (to make it stand out), say in Red. Is this possible?

I am new to this, so the simplest, most direct answer will be greatly helpful.

Thanks.

 

[Catalina]

Look into Conditional Formatting.

Catalina

 

[McObraz]

Catalina,

Thank you very much for the information. Sorry, I would have responded earlier, my internet connection is unstable.

I had looked into conditional formatting before, and maybe I didn't look in the right place, but I didn't find something that suits what I was looking for. What I found are functions that suit numerical and date data, but on my part, I basically want a condition that checks whether the field Is or Is not Null. So, if on the form, the control (say txtNotes) has no data in it, then nothing happens. If, however, there is data, any data in this field, then the whole record in the datasheet is selected in, say red.

Again, thank you very much for your help, much appreciated.

Maurice

 

[McObraz]

Catalina,

Thank you very much for the information. Sorry, I would have responded earlier, my internet connection is unstable.

I had looked into conditional formatting before, and maybe I didn't look in the right place, but I didn't find something that suits what I was looking for. What I found are functions that suit numerical and date data, but on my part, I basically want a condition that checks whether the field Is or Is not Null. So, if on the form, the control (say txtNotes) has no data in it, then nothing happens. If, however, there is data, any data in this field, then the whole record in the datasheet is selected in, say red.

Again, thank you very much for your help, much appreciated.

Maurice