Conditional Formatting of a text-box

[GraeagleBill]

On one of my forms, I want to change the Fore color based on the value of a table field. I have a Public Function named "Status" to which I pass two parameters.



Expression Is Status("ID1","PA")=False

There must be something wrong with the way I coded the conditional formatting, as the function "Status" never receives control. I would have thought that "Status" would be prefixed thus: =Status. However, I get a syntax error if I code the equals sign before the function name.

How should such a reference be coded?

Thanks,
Bill

[pbaldy]

In a brief test:

TestIt([Salary])

worked passing a value to a function. Are you passing fields or literal text? You want the values bracketed if fields.

[June7]

I did a test of Conditional Formatting calling a function and it worked. Can't reproduce issue. Put a breakpoint in the function, does it get executed?

[GraeagleBill]

Paul,

Expression should have been coded: Status([ID1],"PA")=False as ID1 is a field and "PA" is a literal.

The function doesn't need to be invoked if ID1 = 0. How does one code the expression to account for that? If ID1 > 0 then IF Status([ID1],"PA")=False?

And no June, with the expression being wrong the function never ran so there was no breakpoint honored.

Thanks,
Bill

[pbaldy]

Personally I'd handle the ID1 value in the function, but you could use an IIf() as well.

[June7]

Values were provided for both arguments so the function still should have run.

However, issue resolved?

[GraeagleBill]

Yes, that's where I'm in fact dealing with ID1 being zero. The function simply bounces back when ID1 = 0.

Thanks,
Bill

[pbaldy]

I must not be handling this properly, so I'll get out of the way.

[June7]

Paul, I think your contribution to discussion was very relevant and lead to solution.

[GraeagleBill]

Paul,

My post must have been misleading. What I meant was that in that I didn't know how to test the value of ID1 within the conditional formatting statement that I had defaulted to what I know, namely to test the value of ID1 at the entry to the function and return immediately if ID1 is zero. So, your suggestion was right on and that's what I did.

Sorry for the confusion,
Bill