×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Conditional formatting on Yes/No fields

Conditional formatting on Yes/No fields

Conditional formatting on Yes/No fields

(OP)
I have a mystery: I have a form with two sub-forms. Both sub-forms have a Yes/No field denoting whether an item has been marked as completed.

On one subform the conditional formatting works:

Field: txtToDo
Expression is [ToDoComplete]=-1 results in the conditional formatting being applied.

However on the second subform, bound to a different table, the same conditional formatting expression has no effect:

Field: txtSubTask
Expression is [SubTaskComplete]=-1 results in no conditional formatting being applied (even though it should).

Why would conditional formatting on a Yes/No field work on one sub-form and not the other?

RE: Conditional formatting on Yes/No fields

Do the two controls txtToDo and txtSubTask have the same standard format properties such as background etc? Are they both text boxes?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: Conditional formatting on Yes/No fields

If [SubTaskComplete] is a checkbox, you may want to change the expression to [SubTaskComplete]=True

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close