Again, the goal was to change the color of a DBEdit field based on the contents in the field.
A thank you goes out to: Jan, Jim, Buddy and Ken Shapiro over the phone. Issue one was that the DBEdit field was Read Only. Changing colors would not work in that state. Solution: ● Turned off ‘Read Only’ Then changed the opening of the form from Edit using ‘form name’ to Bro using ‘form name’. The fields are not changeable. ● Added a form variable: TEXT vLockBox = RCLockBox in HouseDetail where PropertyIDxx = PropertyIDxx and limit = 1 ● Added an EEP in the ‘On After Start’ IF (IFNULL(.vlockbox,'N',.vlockbox)) = 'Y' THEN PROPERTY cilockbox COLOR 'green' ELSE PROPERTY cilockbox COLOR 'red' ENDIF RETURN Again – thanks for the help!! Myron From: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of jan johansen Sent: June 7, 2020 11:35 AM 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 Well I did a simple test on a DB Edit field where ON ENTRY changed and ON EXIT changed, so I know it works. From: "Myron Finegold" <[email protected] <mailto:[email protected]> > To: <[email protected] <mailto:[email protected]> > Date: Sun, 7 Jun 2020 10:38:11 -0700 Subject: RE: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field Jan, No themes. Myron From: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of jan johansen Sent: June 7, 2020 8:38 AM 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 Myron, Just out of curiosity, are you using themes? Jan From: "Myron Finegold" <[email protected] <mailto:[email protected]> > To: <[email protected] <mailto:[email protected]> > Date: Sat, 6 Jun 2020 13:26:11 -0700 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/00a601d63c40%24b8fc3c00%242af4b400%24%40gmail.com <https://groups.google.com/d/msgid/rbase-l/00a601d63c40%24b8fc3c00%242af4b400%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] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20200607153813.090006%40jjcalibrations.com <https://groups.google.com/d/msgid/rbase-l/WC20200607153813.090006%40jjcalibrations.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/017b01d63cf2%246ac49a70%24404dcf50%24%40gmail.com <https://groups.google.com/d/msgid/rbase-l/017b01d63cf2%246ac49a70%24404dcf50%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] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20200607183440.05000B%40jjcalibrations.com <https://groups.google.com/d/msgid/rbase-l/WC20200607183440.05000B%40jjcalibrations.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/002501d63d1f%24fcac7750%24f60565f0%24%40gmail.com.
