changing textbox color

[Guest]

I want to change textbox color of a form, according to data on it.

 

[Al Camp]

dn,
For Access 2000 and up, use Conditional Formatting.

 

[Guest]

Hi,

thanks,..
but can I change the appearence of one textbox according to value change of
another textbox.

dn

 

[Ron2006]

Yes you can.

in the afterupdate event of the changing txtbox

if (condition) then
me.txtboxtobechangedname.forecolor = (a number for color
etc. you can get to forecolor backcolor, bolding, font etc
essential anything that is in the format tab of the txtbox
you want to change.
endif