chang label based on yes/no box
chang label based on yes/no box
(OP)
I have a “no phone” column in my table. If it is marked (it is yes/no) yes then I would like to make the label turn red when the record is viewed.
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
chang label based on yes/no box
|
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.
RE: chang label based on yes/no box
If me![no phone] = 0 then
me!Label.backcolor = vbred
else
me!Label.backcolor = vbwhite
end if
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.