changing textbox color

dn · May 30, 2006

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

Al Camp · May 30, 2006

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

dn · May 31, 2006

Hi,

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

dn

Ron2006 · May 31, 2006

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

changing textbox color

dn

Al Camp

dn

Ron2006