Re: Sub-Form Control Backcolor based on varying criteria
- From: Raas <Raas@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 20 May 2007 19:36:03 -0700
Thank you Perry, and thank you all as well as the University ???
That worked.
"Perry" wrote:
I take it we're talking continuous subforms:.
http://www.mvps.org/access/forms/frm0024.htm
--
Krgrds,
Perry
System:
Vista/Office Ultimate
VS2005/VSTO2005 SE
"Raas" <Raas@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:3C73FA9F-F65D-44A7-9567-0CAAB645E126@xxxxxxxxxxxxxxxx
Thanks for the reply, but unfortunately, it doesn't address the question.
Each field on the sub-form needs to be able to have its own color, and
changable as the criterion changes. Just changing the detail section
won't
do it.
"Perry" wrote:
Change the BackColor of the Detail section of the subform (form) to yr
liking.
--
Krgrds,
Perry
System:
Vista/Office Ultimate
VS2005/VSTO2005 SE
"Raas" <Raas@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:E4E648FE-4CFE-4705-AAC1-182361B74F5D@xxxxxxxxxxxxxxxx
I have a subform that displays only two fields : Category and ColorCode.
I input a category, (i.e. "Sexual Abuse") and the code will search the
appropriate table and pull the colorcode as being "Red" and display the
text
in the ColorCode control on the subform. No problem.
However, the attorney involved wants me to be able to color the
background
of the control to red. I can do that no problem, except that all
colorcodes
then are displayed as red. There could be many categories being
displayed
on
the sub form, as in:
Sexual Abuse Red
Physical Abuse Purple
Intimidation Green etc.
The attorney wants quick visual access when in court using a laptop, to
be
able to show the red category in red, the purple in purple, and green
in
green, etc.
Is is possible on a sub-form that really only uses one control and
replicates itself as needed for display? I thought I once saw some code
to
this effect, but????????
- References:
- Prev by Date: Procedure call to Main Form from subform fires once but not thereafter
- Next by Date: Re: Combo Box Filter
- Previous by thread: Re: Sub-Form Control Backcolor based on varying criteria
- Next by thread: Re: Sub-Form Control Backcolor based on varying criteria
- Index(es):
Relevant Pages
|
