changing the forecolor of the textfield

[indhu]

hi all,

i have a text field called STATUS. if i enter "completed" in that textbox it should become green color else red.

can u tell, how to change a forecolor of my text field. How to code for this ya.

[PEB]

Hi,

To understand the the values for red green and other colors go and change the color of a field manually...

Than save somewhere the value that you want to set automaticlly

On the current form property choose Event procedure and

Type

If me![Status]="Completed" then
me![Status].backcolor=4566565 'value that you've tested
me![Status].forecolor=4566565 'value that you've tested

ELSE
me![Status].backcolor=4566565 'value that you've tested
me![Status].forecolor=4566565 'value that you've tested

end if

See the name of the properties that you've tested I think it should be fore and back color but not sure...

[indhu]

hi its

Actually working but didn't met the criteria. see if status= "completed" it should be green in color else red in color. what happen here is while loading the form both "completed" and "inprogress" appears green in color when I click the colum then turns to red color. this way I don't want.

if status completed "green". else "inprogress = "red"

pls help me

[indhu]

hi,

i have a list box in my form, when i click listbox field it should display corresponding value to other textbox fields.

like
listbox,[ task, status, start date, end date] these are the corresponding text flds
person by clicking this it should display other field values

[missinglinq]

If you're using Access 2000 or later, the simplest thing to do iss use Conditional Formatting!

In Design View select the control, goto Format > Contional Formatting then set your conditions. You can choose the colors you wish for each condition from a pallette.

[NeoPa]

If you re-read PEB's post and follow the instructions there, it tells you how to set it to the values you want.
You DO have to find them first.

[NeoPa]

If you're using Access 2000 or later, the simplest thing to do iss use Conditional Formatting!

In Design View select the control, goto Format > Contional Formatting then set your conditions. You can choose the colors you wish for each condition from a pallette.

This looks like a better solution though. I didn't realise this facility was available in Access!

[indhu]

If you're using Access 2000 or later, the simplest thing to do iss use Conditional Formatting!

In Design View select the control, goto Format > Contional Formatting then set your conditions. You can choose the colors you wish for each condition from a pallette.

hi
thank u so much ya

its working.

do u ve any idea by changing in coding part.

[indhu]

This looks like a better solution though. I didn't realise this facility was available in Access!

its working.. i ve followed PEBs coding but problem in that is its showing green color when i click the status it turns to red. not differentiated the completed and inprogress

thank u for the effort u all took yeah.

[indhu]

Hi,

To understand the the values for red green and other colors go and change the color of a field manually...

Than save somewhere the value that you want to set automaticlly

On the current form property choose Event procedure and

Type

If me![Status]="Completed" then
me![Status].backcolor=4566565 'value that you've tested
me![Status].forecolor=4566565 'value that you've tested

ELSE
me![Status].backcolor=4566565 'value that you've tested
me![Status].forecolor=4566565 'value that you've tested

end if

See the name of the properties that you've tested I think it should be fore and back color but not sure...

hi

thanks yeah

its working, i ve removed ME prefix and just gave status. its working fine