Myron
I believe you need quotes around the variable name in GETPROPERTY.
Buddy
SET VAR vwho TEXT = 'Y'
GETPROPERTY dbwho TEXTVALUE 'vWho'
IF vWho IS NULL THEN
RETURN
ENDIF
IF vwho = 'Y' THEN
PROPERTY dbwho COLOR 'Blue'
ELSE
PROPERTY dbwho COLOR 'AQUA'
ENDIF
RETURN
From: [email protected] <[email protected]> On Behalf Of Myron
Finegold
Sent: Saturday, June 6, 2020 5:58 PM
To: [email protected]
Subject: RE: [RBASE-L] - DB Edit Field - Change the field background color
based on the value in the field
Jim,
Thanks. A no go.
I am back in the manuals trying to get a better understanding of the Property
and Get Property commands.
I’ll let you know.
Myron
From: 'Jim Belisle' via RBASE-L <[email protected]
<mailto:[email protected]> >
Sent: June 6, 2020 1:58 PM
To: [email protected] <mailto:[email protected]>
Subject: RE: [RBASE-L] - DB Edit Field - Change the field background color
based on the value in the field
I would try to change two things.
1. Create your var vwatch1 in the “on after start” EEP of the form. That
way you are not creating it each time you enter the field.
2. Then use the var vwatch1 to make the color change, not the component ID
name.
IF vwatch1 = 'Y' THEN
PROPERTY cilockbox COLOR 'green'
ELSE
PROPERTY cilockbox COLOR 'red'
ENDIF
RETURN
Try that
James Belisle
Making Information Systems People Friendly Since 1990
From: [email protected] <mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Myron Finegold
Sent: Saturday, June 6, 2020 3:26 PM
To: [email protected] <mailto:[email protected]>
Subject: [RBASE-L] - DB Edit Field - Change the field background color based on
the value in the field
What Object: DB Edit Field
Desire: to the background color change based on the value in the column. This
will be a ‘Y’ or an ‘N’.
The DB Edit field has been given a unique component ID. ciLockBox
A custom EEP has been put into the ‘On Enter’ choice
PROPERTY ciLockBox COLOR 'white'
RETURN
A custom EEP has been put into the ‘On Exit’ choice
SET VAR vwatch1 TEXT = NULL
GETPROPERTY cilockbox TEXTVALUE vwatch1
IF vwatch1 IS NULL THEN
RETURN
ENDIF
IF cilockbox = 'Y' THEN
PROPERTY cilockbox COLOR 'green'
ELSE
PROPERTY cilockbox COLOR 'red'
ENDIF
RETURN
This isn’t working. As they say I have hit the wall. Any suggestions would be
appreciated.
Myron Finegold
Sheriff’s Posse of Sun City West
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected]
<mailto:[email protected]> .
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339494B4B967F8CF8E613088A0870%40CY4PR0201MB3394.namprd02.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339494B4B967F8CF8E613088A0870%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>
.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected]
<mailto:[email protected]> .
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/002d01d63c4d%24842da2e0%248c88e8a0%24%40gmail.com
<https://groups.google.com/d/msgid/rbase-l/002d01d63c4d%24842da2e0%248c88e8a0%24%40gmail.com?utm_medium=email&utm_source=footer>
.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/000201d63cc3%24a0aa8f70%24e1ffae50%24%40comcast.net.
