Conditional formatting stops working after changing field type

[jhollingsh615]

I have a form that is based on a query from a single table. Two of the fields on the form were yes/no fields with conditional formatting(red background if field = "no"). This is a split database.
After changing the yes/no fields in the backend to text fields, I can no longer get conditional formatting to work on the form, for those fields. Actually, conditional formatting works if I use only the "has focus" option of the default conditional formatting tab. But, it does not work for field = =



I am at a loss what I could have done.

[ItsMe]

Why don't you get rid of conditional formatting and manage it with VBA? Maybe the "AfterUpdate" event...

Something like

If me.NameOfControl = "False" then
me.NameOfControl.forecolor = 255
else
me.NameOfControl.forecolor = 0
end if

[jhollingsh615]

ItsMe, thanks for the quick response. Truth is, my coding knowledge is almost nil. I tend to create more problems than I solve when I try it. Was hoping to avoid more.
And this was working great before I changed the underlying field. Even now, it works with the "has focus" option. Other fields can handle the "equal to" option, so I'm sure it has something to do with me changing the field type from yes/no to text. For the life of me I can't figure it out.
But, I will try to run some tests with the VBA, if you say it is that simple.....

[ItsMe]

The complicated part is textbox control vs. checkbox control. It will be difficult to restrict what the user types into a textbox. You are trying to validate literal text and the slightest typo could remove any constraint you are trying to enforce. What is stopping the user from typing "Sure" or "Maybe" in the textbox? How are you going to validate input like that?

[Missinglinq]

...After changing the yes/no fields in the backend to text fields, I can no longer get conditional formatting to work on the form...

Just to be clear, you did change the expression in the Conditional Formatting, correct?

[WhateverField] = Yes

works for a Yes/No (Boolean) Field, but if the Field has been changed to Text the expression would have to be changed to

[WhateverField] = "Yes"

And ItsMe makes a very valid point; you'll have to validate that either "Yes" or "No" has been entered, or you'll have problems.

Linq ;0)>

[jhollingsh615]

Itsme and Missinglinq,
Thank you both very much for responding so quickly. The field in question is only modified through a combo box with only "yes" or "no" as options.
Missinglinq, as silly as I feel now, you identified the problem head on. Putting the quotes fixed everything.
Thanks guys!!

[Missinglinq]

As everyone here will tell you, 'databases' are all about the 'data,' and not all 'data' is the same! You have to know the Datatype in order to know how to handle it!

Glad we could help!

Good luck with your project!

Linq ;0)>