Connecting Tech Pros Worldwide Forums | Help | Site Map

Where to look for textbox background color change at runtime

Roberto Castro
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Where to look for textbox background color change at runtime


Look at the OnCurrent event of the form.

"Roberto Castro" <jrcastro20@yahoo.com> wrote in message
news:4eef7255.0310220705.49b28ebd@posting.google.c om...[color=blue]
> 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[/color]


Wayne Morgan
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Where to look for textbox background color change at runtime


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" <jrcastro20@yahoo.com> wrote in message
news:4eef7255.0310220705.49b28ebd@posting.google.c om...[color=blue]
> 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[/color]


Roberto Castro
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Where to look for textbox background color change at runtime


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

Jose R. Castro

"Wayne Morgan" <comprev_gothroughthenewsgroup@hotmail.com> wrote in message news:<DSClb.10692$fI5.3766@newssvr16.news.prodigy. com>...[color=blue]
> 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" <jrcastro20@yahoo.com> wrote in message
> news:4eef7255.0310220705.49b28ebd@posting.google.c om...[color=green]
> > 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[/color][/color]
Closed Thread