Where to look for textbox background color change at runtime

[Roberto Castro]

Hello!

I have been assigned for the first time an adp Access project and so
far I have managed to make the changes needed for some requirements.
However, I am struggling to find the place where the application
changes the color of the background of a textbox. Here the explanation
goes:

This is a form bound to an SQL view. The detail section has several
fields, one of them being a textbox of name "Type". I checked its
properties and the color for the background (Back Color property in
the Format tab) is 16777215 (white). When the form is loaded the
background color changes to yellow when the value of "Type" is "W"
(and the font even changes to Bold!!). I am sure the previous
programmer had a reason for that but I have searched the string "Type"
in the whole project and I could not find any place where this
property was modified by code.

Does anybody have an idea where I can look for the specific place
where the application makes changes in the properties of the textbox
when it loads its value? All hints will be greatly appreciated!

Regards,

Jose R. Castro

[paii]

Look at the OnCurrent event of the form.

"Roberto Castro" <jr********@yahoo.com> wrote in message
news:4e**************************@posting.google.c om...

Hello!

I have been assigned for the first time an adp Access project and so
far I have managed to make the changes needed for some requirements.
However, I am struggling to find the place where the application
changes the color of the background of a textbox. Here the explanation
goes:

This is a form bound to an SQL view. The detail section has several
fields, one of them being a textbox of name "Type". I checked its
properties and the color for the background (Back Color property in
the Format tab) is 16777215 (white). When the form is loaded the
background color changes to yellow when the value of "Type" is "W"
(and the font even changes to Bold!!). I am sure the previous
programmer had a reason for that but I have searched the string "Type"
in the whole project and I could not find any place where this
property was modified by code.

Does anybody have an idea where I can look for the specific place
where the application makes changes in the properties of the textbox
when it loads its value? All hints will be greatly appreciated!

Regards,

Jose R. Castro

[Wayne Morgan]

As mentioned, it could be in the OnCurrent event of the form. It could also
be in the AfterUpdate event of the control and a couple of other places. The
first place I'd look though would be in Conditional Formatting. Open the
form in design mode, right click the control, and choose Conditional
Formatting...

--
Wayne Morgan
"Roberto Castro" <jr********@yahoo.com> wrote in message
news:4e**************************@posting.google.c om...

Hello!

I have been assigned for the first time an adp Access project and so
far I have managed to make the changes needed for some requirements.
However, I am struggling to find the place where the application
changes the color of the background of a textbox. Here the explanation
goes:

This is a form bound to an SQL view. The detail section has several
fields, one of them being a textbox of name "Type". I checked its
properties and the color for the background (Back Color property in
the Format tab) is 16777215 (white). When the form is loaded the
background color changes to yellow when the value of "Type" is "W"
(and the font even changes to Bold!!). I am sure the previous
programmer had a reason for that but I have searched the string "Type"
in the whole project and I could not find any place where this
property was modified by code.

Does anybody have an idea where I can look for the specific place
where the application makes changes in the properties of the textbox
when it loads its value? All hints will be greatly appreciated!

Regards,

Jose R. Castro

[Roberto Castro]

Wayne, thanks for your help. Conditional formatting was used to make
this change at runtime.

Jose R. Castro

"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<DS******************@newssvr16.news.prodigy. com>...

As mentioned, it could be in the OnCurrent event of the form. It could also
be in the AfterUpdate event of the control and a couple of other places. The
first place I'd look though would be in Conditional Formatting. Open the
form in design mode, right click the control, and choose Conditional
Formatting...

--
Wayne Morgan
"Roberto Castro" <jr********@yahoo.com> wrote in message
news:4e**************************@posting.google.c om...

Hello!

I have been assigned for the first time an adp Access project and so
far I have managed to make the changes needed for some requirements.
However, I am struggling to find the place where the application
changes the color of the background of a textbox. Here the explanation
goes:

This is a form bound to an SQL view. The detail section has several
fields, one of them being a textbox of name "Type". I checked its
properties and the color for the background (Back Color property in
the Format tab) is 16777215 (white). When the form is loaded the
background color changes to yellow when the value of "Type" is "W"
(and the font even changes to Bold!!). I am sure the previous
programmer had a reason for that but I have searched the string "Type"
in the whole project and I could not find any place where this
property was modified by code.

Does anybody have an idea where I can look for the specific place
where the application makes changes in the properties of the textbox
when it loads its value? All hints will be greatly appreciated!

Regards,

Jose R. Castro