Check box?

[Matthew R White]

I have a check box thats currently having some on/off issues.

The field of the checkbox (QuotedStatus) can be checked with the value "Quoted"

 

I have another field that basically says if QuotedStatus = "Quoted" Then...

However its not working... its not recognizing the "Quoted" when the box is checked.

 

Anything I'm missing?

[Lee Smith]

Post your calculation.

[Matthew R White]

Its a portal filtered by this:

 

BWIA2 FMP11 2::ACCT CODE 1 = "RQ" and Month ( Get ( CurrentDate )) & "/" & Year ( Get ( CurrentDate ) ) = Month ( BWIA2 FMP11 2::EFFECTIVE DATE ) & "/" & Year ( BWIA2 FMP11 2::EFFECTIVE DATE ) and BWIA2 FMP11 2::PRODUCER CODE = "3" and BWIA2 FMP11 2::QUOTED STATUS = "Quoted"

[eos]

I have a check box thats currently having some on/off issues.

The field of the checkbox (QuotedStatus) can be checked with the value "Quoted"

 

I suggest that you a number field with a 1/0 value list for your Boolean fields; they can only be in one of two states, the meaning is clear from the field name, you can add a label on the layout (there are even Boolean formatting options for short texts), and calculations boil down to a simple query like this one: 

 

Case ( quoted? ; // your result … )

 

 have another field that basically says if QuotedStatus = "Quoted" Then...

However its not working... its not recognizing the "Quoted" when the box is checked.

 

Anything I'm missing?

 

For your current issue: if in doubt, display the field as edit box and inspect its contents. The checkbox means a certain value is present, but not necessarily that the field is identical to that value.