Dynamicforecolor

[LouisC4]

Hello, I am getting this message when I am assigning a dynaicforecolor to my grid.

error message is:

Expression is invalid. Use a valid expression for DYNAMICFORECOLOR property

Here is the code I am using:

acn = "512343"

ThisForm.grdGl_journal.SetAll("DynamicForeColor",;
"IIF(acc_num = acn, RGB(0,0,200), RGB(0,0,0))", "Column&quot


However the code works fine when I do this:

ThisForm.grdGl_journal.SetAll("DynamicForeColor",;
"IIF(acc_num = "512343", RGB(0,0,200), RGB(0,0,0))", "Column&quot


Any suggestions?

Louis

 

[Mike Gagnon]

Loui4C

It the acn variable "outside" of the init? Perhaps a local varariable that goes out of scope? Try making the variable public.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[darrellblackhawk]

Change it to:

ThisForm.grdGl_journal.SetAll("DynamicForeColor",;
"IIF(acc_num = eval('acn'), RGB(0,0,200), RGB(0,0,0))", "Column&quot

Note the apostrophes VS quotes in the eval() call

Darrell



'We all must do the hard bits so when we get bit we know where to bite'

 

[LouisC4]

Thanks for your input Mgagnon and Darrel,

Mike, I do declare acn in the ini method and I have tried it public, it still wont work.

Darrel, I still get the same message with your method and I did use EVAL('acn') and not EVAL("acn&quot. I've even tried it without the quote.

Any other ideas?

thanks again,

Louis

 

[LouisC4]

Hi all,

I got it to work. The solution was using EVAL('acn') as Darrell said. My error was that I had changed the assigning of acn from:

acn = "512343" to acn = '512343'

Now it works fine.

Thanks again,

Louis