[RBASE-L] - Re: Form Tier Question

[anne]

Thank You Alastair and Karen.

Will give this a try.

Cheers!

Anne

-------- Original Message --------
Subject: [RBASE-L] - Re: Form Tier Question
From: "Alastair Burr" <alastair.b...@ntlworld.com>
Date: Fri, October 23, 2009 3:32 am
To: rbase-l@rbase.com (RBASE-L Mailing List)



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: a...@redcaptransport.net

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