Sytze,
Not a problem. I think you're almost there.
I assume the lines of your code below were joined by Outlook and you don't
really have ;'s in the middle of the commands (as happened to me before)
Syntax being okay, try running your code in INIT, after the grid object is
created on the form (and it is named GRID1, right?)
If doesn't work, try using the debugger to confirm your columnsource for
example column 6
_vfp.ActiveForm.grid1.column6.controlsource if not "courc6"
or "sp605.courc6", that's a problem
Is rgb(255,255,0) the color you want for the colored cells?
You should be good to go
Bill
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of
Sytze de Boer
Sent: Friday, October 12, 2012 12:27 AM
To: [email protected]
Subject: Re: Cell color
I have placed the following in the init event of the gird It does absolutely
nothing
Bill, I have wasted a lot of your time and I do appreciate it.
This is now becoming an imposition so please don't feel obliged
Thisform.Grid1.Columns(2).DynamicBackColor = ; "IIF(ATC('BYE',
sp605.courtc1) <> 0,RGB(255,255,0),RGB(255,255,255))"
Thisform.Grid1.Columns(3).DynamicBackColor = ; "IIF(ATC('BYE',
sp605.courtc2) <> 0,RGB(255,255,0),RGB(255,255,255))"
Thisform.Grid1.Columns(4).DynamicBackColor = ; "IIF(ATC('BYE',
sp605.courtc3) <> 0,RGB(255,255,0),RGB(255,255,255))"
Thisform.Grid1.Columns(5).DynamicBackColor = ; "IIF(ATC('BYE',
sp605.courtc4) <> 0,RGB(255,255,0),RGB(255,255,255))"
Thisform.Grid1.Columns(6).DynamicBackColor = ; "IIF(ATC('BYE',
sp605.courtc5) <> 0,RGB(255,255,0),RGB(255,255,255))"
Thisform.Grid1.Columns(7).DynamicBackColor = ; "IIF(ATC('BYE',
sp605.courtc6) <> 0,RGB(255,255,0),RGB(255,255,255))"
--
Kind regards
Sytze de Boer
Kiss Software
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
