|
 |
access thread: Text box COLOR for Continuous Form
Message #1 by Adriane.Delvillar@a... on Thu, 16 May 2002 19:49:16 +0800
|
|
This is a multipart message in MIME format.
--=_alternative 00402BBA48256BBB_
Content-Type: text/plain; charset="us-ascii"
Hi there!
Is it possible to set the colors of the textbox in a continuous
form?
For example, i have a subform on my main form.That subform has two
text box's for the columns Code and NAME.
If the value of the code is 1, then the background color's of the
Code
and NAME textbox's will be GREEN, if 0 or null, then the background
color's of the Code
and NAME textbox's will be BLUE.
Inside the subform:
Code NAME
1 ian --> background color of their textbox will be
GREEN
0 den --> background color of their textbox will be BLUE
1 myr --> background color of their textbox will
be GREEN
0 jolitz --> background color of their textbox will
be BLUE
PLEASE I NEED HELP.......
ian
Message #2 by ProDev <prodevmg@y...> on Thu, 16 May 2002 07:28:22 -0700 (PDT)
|
|
--0-48506974-1021559302=:39074
Content-Type: text/plain; charset=us-ascii
If you have A2K you can use the conditional formatting feature.
If you have A97, then you will have to use smoke and mirrors.
You would create an additional text box, make it transparent, put it under the text box you want to change color, set a special font
(wingdigs or terminal), then select a character that looks like a block, set a condition in your vba or record source that says "If
something happens, Then set the record source to my special character.
It's not as complicated as it sounds. I have a sample database that shows how. If you want it, email me at this address and state
which database you want.
ljprodev@y...
Adriane.Delvillar@a... wrote:
Hi there!
Is it possible to set the colors of the textbox in a continuous form?
For example, i have a subform on my main form.That subform has two
text box's for the columns Code and NAME.
If the value of the code is 1, then the background color's of the Code
and NAME textbox's will be GREEN, if 0 or null, then the background color's of the Code
and NAME textbox's will be BLUE.
Inside the subform:
Code NAME
1 ian --> background color of their textbox will be GREEN
0 den --> background color of their textbox will be BLUE
1 myr --> background color of their textbox will be GREEN
0 jolitz --> background color of their textbox will be BLUE
PLEASE I NEED HELP.......
ian
--- Change your mail options at http://p2p.wrox.com/manager.asp or
Lonnie Johnson
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV
---------------------------------
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
Message #3 by Richard Gibson <rgibson@W...> on Thu, 16 May 2002 15:49:49 +0100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1FCE8.EDDD64EA
Content-Type: text/plain;
charset="iso-8859-1"
If you're using Access 2000 try experimenting with conditional formatting -
it's on the "format" menu.
Regards
Richard Gibson
IT Manager
The information in this message is confidential and intended for the
addressee only. If you have received this message in error please delete
and notify the sender, any other action may be unlawful.
The views expressed in this message are personal and not necessarily those
of Walkerpack Ltd unless explicitly stated.
-----Original Message-----
From: Adriane.Delvillar@a...
[mailto:Adriane.Delvillar@a...]
Sent: 16 May 2002 12:49
To: Access
Subject: [access] Text box COLOR for Continuous Form
Hi there!
Is it possible to set the colors of the textbox in a continuous
form?
For example, i have a subform on my main form.That subform has two
text box's for the columns Code and NAME.
If the value of the code is 1, then the background color's of the
Code
and NAME textbox's will be GREEN, if 0 or null, then the background color's
of the Code
and NAME textbox's will be BLUE.
Inside the subform:
Code NAME
1 ian --> background color of their textbox will
be GREEN
0 den --> background color of their textbox will
be BLUE
1 myr --> background color of their textbox will
be GREEN
0 jolitz --> background color of their textbox
will be BLUE
PLEASE I NEED HELP.......
ian
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #4 by "David Chapman" <luckychap@b...> on Fri, 17 May 2002 20:35:49 +0930
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C1FDE2.6E27E8B0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
There is a way of doing this. It is not easy and there is a msdn article on
it.
It envoles duplicating and overlaying the textbox, hence the different
colours. The record source has to be a query that provides a space under the
condition that you require a different colour to appear. It uses the
principle that the contol on top is marked "send to back" (an option on the
format menu), which it does if there is nothing in the contol. Wonderful
stuff.
I will not be back in the office until Wednesday, if nobody else remembers
and I have not put you off, ask an I will look it up, but you willhave to
wait.
David
-----Original Message-----
From: Adriane.Delvillar@a...
[mailto:Adriane.Delvillar@a...]
Sent: Thursday, May 16, 2002 9:19 PM
To: Access
Subject: [access] Text box COLOR for Continuous Form
Hi there!
Is it possible to set the colors of the textbox in a continuous
form?
For example, i have a subform on my main form.That subform has two
text box's for the columns Code and NAME.
If the value of the code is 1, then the background color's of the
Code
and NAME textbox's will be GREEN, if 0 or null, then the background
color's of the Code
and NAME textbox's will be BLUE.
Inside the subform:
Code NAME
1 ian --> background color of their textbox
will be GREEN
0 den --> background color of their textbox
will be BLUE
1 myr --> background color of their textbox
will be GREEN
0 jolitz --> background color of their textbox
will be BLUE
PLEASE I NEED HELP.......
ian
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #5 by Adriane.Delvillar@a... on Sat, 18 May 2002 08:51:24 +0800
|
|
This is a multipart message in MIME format.
--=_alternative 0003FF4448256BBD_
Content-Type: text/plain; charset="us-ascii"
i can wait.
MAY THE FORCE BE WITH YOU,
DEL VILLAR, ADRIANE WILSON S.
"David Chapman" <luckychap@b...>
05/17/2002 07:05 PM
Please respond to "Access"
To: "Access" <access@p...>
cc:
Subject: [access] RE: Text box COLOR for Continuous Form
There is a way of doing this. It is not easy and there is a msdn article
on it.
It envoles duplicating and overlaying the textbox, hence the different
colours. The record source has to be a query that provides a space under
the condition that you require a different colour to appear. It uses the
principle that the contol on top is marked "send to back" (an option on
the format menu), which it does if there is nothing in the contol.
Wonderful stuff.
I will not be back in the office until Wednesday, if nobody else remembers
and I have not put you off, ask an I will look it up, but you willhave to
wait.
David
-----Original Message-----
From: Adriane.Delvillar@a...
[mailto:Adriane.Delvillar@a...]
Sent: Thursday, May 16, 2002 9:19 PM
To: Access
Subject: [access] Text box COLOR for Continuous Form
Hi there!
Is it possible to set the colors of the textbox in a continuous
form?
For example, i have a subform on my main form.That subform has two
text box's for the columns Code and NAME.
If the value of the code is 1, then the background color's of the
Code
and NAME textbox's will be GREEN, if 0 or null, then the background
color's of the Code
and NAME textbox's will be BLUE.
Inside the subform:
Code NAME
1 ian --> background color of their textbox
will be GREEN
0 den --> background color of their textbox
will be BLUE
1 myr --> background color of their textbox
will be GREEN
0 jolitz --> background color of their textbox
will be BLUE
PLEASE I NEED HELP.......
ian
--- Change your mail options at http://p2p.wrox.com/manager.asp or
---
|
|
|
View Cart
