Conditional Formating

[kitty77]

Using conditional formatting, how would the code look if I wanted to find any records in [field1] with the word "Apple" in it.

Thanks.

 

[Pat Hartman]

Select the control you want to format.

 

[kitty77]

Not equal, needs to be contains the word "Apple"

 

[isladogs]

Expression Is ... [Field1] Like "*apple*"

 

[Pat Hartman]

Thanks Col, I'm too tired to be answering questions

 

[kitty77]

Expression Is ... [Field1] Like "*apple*"

View attachment 104039

Thanks!

 

[Cotswold]

Maybe of interest regarding Conditional Formatting? Until the other week I'd no idea that this happened and have posted it in case it may be of interest or use.

I created a datasheet form with conditional formatting and added it as an object to its main form. If instead of adding new unbound fields to the main form I copied and pasted the fields from the datasheet. The conditional formatting morphed over with the copied fields.

So when the condition was met on the datasheet, the colours changed accordingly to the fields on the main form. There is no way that you can
then see or amend those settings to the fields on the main form. Or so it appears! I've attached an example in Access2010.

 

[isladogs]

Sorry but you've lost me....
I can see the conditional formatting conditions on both forms.
Two conditions on the subform. 4 conditions (one not in use) on the main form
Have I misunderstood your comments?

 

[Cotswold]

Sorry but you've lost me....
I can see the conditional formatting conditions on both forms.
Two conditions on the subform. 4 conditions (one not in use) on the main form
Have I misunderstood your comments?

Not at all it does appear!

I have used Access since it was called Access97 and have never noticed, so never used the Conditional Formatting on a Field dropdown
from the right-click! In fact, I've come to think of it, I've never used Anchoring, Fill/BackColor, Font/ForeColor or SpecialEffect from the drop-down either from there either! I've used the Property Sheet almost exclusively.

Now I'm just thinking about the code I've written to do just that over the years

 

[isladogs]

Ha! Glad to have helped (indirectly).
For info, conditional formatting wasn't added until Access 2002.
It has been included in the context menu from then onwards....

If interested in a review of all Access versions from v1.0 onwards, see my article:

A Trip Down Memory Lane

This article reviews the main changes in Access features and appearance from its first release in 1992 through to the current day.

www.isladogs.co.uk

 

[Cotswold]

That explains it. I moved from Access97 to Access2000 and used it for all development professionally until 2014. Although I bought 2010 when it came out I didn't use it until maybe 2018 or later, then I updated to Access2019.

I used to tell clients ; "Read the screen" Maybe I should have practiced what I preached? I must have looked at that dropdown thousands of times and just didn't see the bits I'd never used. Or pay attention to what I was looking at.

 

[isladogs]

We all do that. Very hard to break old habits even when better methods become available