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 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Myron Finegold Sent: Saturday, June 6, 2020 3:26 PM To: [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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB339494B4B967F8CF8E613088A0870%40CY4PR0201MB3394.namprd02.prod.outlook.com.
