[AccessD] A2003: Formatting a text Box

Bryan Fitzpatrick bryan.fitzpatrick at cyberone.com.au
Wed Feb 2 03:47:15 CST 2005


Darren
The FORMAT  propertyof a textbox allows some control of this.  Check it 
in the on-line Help.  I know that you can set up to four different 
formats for a number field, but I'm not sure if it works for text.

HTH
bryan

Darren DICK wrote:

>Hello all
>I want the text in a text box to be blue or red depending on conditions
>
>Can it be done in the control source of the Control?
>I know it can be done via Conditional Formatting or in code
>Just wanna know if it can be done in the control source
>
>EG (pseudo code)
>
>=IIf([SomeValue]=-1,Format([SomeControl].ForeColor,"vbred","vbblue"))
>
>Many thanks
>
>Darren
>
>
>
>
>  
>



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.3 - Release Date: 31/01/2005




More information about the AccessD mailing list