By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

Where to look for textbox background color change at runtime

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.