[AccessD] A2003: Formatting a text Box

Hi Darren,
This is what I have done on a continuous form (Access97):

In order to display text
"In Progress"   in green
or
"Closed Out"    in red

depending on a flag setting with value held in chkFinalFlag on the Form,

I created two textboxes
txtFinalFlagTextgreen
txtFinalFlagTextred
with transparent background and forecolor as required and placed them on top
of each other

Control Source set to, txtFinalFlagTextgreen:
=IIf([chkFinalFlag]=-1,"","
In
Progress")

and txtFinalFlagTextgred:
=IIf([FinalFlag]=-1,"
Closed","")

HTH

Borge,



----- Original Message ----- 
From: "Darren DICK" <d.dick at uws.edu.au>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Thursday, February 03, 2005 10:17 AM
Subject: RE: [AccessD] A2003: Formatting a text Box


> Many thanks
> That's what I thought
>
> See ya
>
> DD
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
> Sent: Thursday, 3 February 2005 9:38 AM
> To: Access Developers discussion and problemsolving
> Subject: RE: [AccessD] A2003: Formatting a text Box
>
> On 3 Feb 2005 at 9:31, Darren DICK wrote:
>
> > Hey Gustav
> > Beautiful -
> > Now the big bit that I forgot to mention in my previous post <blush>
> >
> > Will this work on a Continuous Form?
> >
>
> AAAAAAAAAAH!   <VBG>
>
> Nope, you'll have to use conditional formatting for that.
>
> --
> Stuart
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.4 - Release Date: 1/02/2005
>
>



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.4 - Release Date: 1/02/2005