Anne, Below is the help I got from Karen on this sort of thing:
Alastair: Not sure if you meant me and what I posted. My posting is a very simple example, where you just want a word to appear in a certain color if a condition exists. This works in a region. You just define your form variable as I show below in the IFEQ, having a blank as the result if you want nothing to appear. You locate the form variable as a label in your region, and assign the color red. This does NOT address having the variable change colors depending on a condition or not. I suppose you could have 2 variables, with 2 different colors, if you could work that into your display so that it makes sense. Karen Sami: I assume you want to change a DBEdit field? If so, then I agree with Larry. But Labels will evaluate fine per row. I do that all the time. If it's an editable field, anyway you can get around with putting words around the field in a color? Like maybe defining a form expression: vAsterisks = (IFGT( columnname, 0, ' ', '****')) and make the field red? Karen It works brilliantly! (Thanks, Karen.) I have a form where I display an image that indicates whether a row has complete data or not and which (or both) of two fields is incomplete. I use four images to achieve this - effectively a blank image and one each for both and the two fields. Regards, Alastair. ----- Original Message ----- From: [email protected] To: RBASE-L Mailing List Sent: Thursday, October 22, 2009 7:07 PM Subject: [RBASE-L] - Form Tier Question Is there any way with a form, using a tier, to set the background color and or font for an individual row and or column when a condition exists for that row? Have done this with a DB Grid - under properties - effect: the background color field and or font color can be changed, based on table information. Thanks, Anne ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.423 / Virus Database: 270.14.26/2451 - Release Date: 10/22/09 08:51:00
