Datasheet View

[AgentX@apocalypse.com]

Is it possible, In a datasheet view subform, to change the backgound
color based on the value in a particular field? For example if the
field is Yes/No, have the background color red for No and Green for
Yes?
Any help is greatly appreciated

[fredg]

Re: Datasheet View

On Mon, 21 Feb 2005 05:31:17 GMT, AgentX@apocalyp se.com wrote:
[color=blue]
> Is it possible, In a datasheet view subform, to change the backgound
> color based on the value in a particular field? For example if the
> field is Yes/No, have the background color red for No and Green for
> Yes?
> Any help is greatly appreciated[/color]

In FORM Datasheet View?
If you're using Access 2000 or newer...
For a regular Text control, Yes.
For a Check Box control, No.

For a regular text control:

In Form Design View, select the Control.
Click on Format + Conditional Formatting.
Set the Condition1 'Field Value Is' to whatever value is required.
Select your colors.
Save the changes.

A Check box control does not have the capability of changing it's
color formatting.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Tom van Stiphout]

Re: Datasheet View

On Mon, 21 Feb 2005 05:31:17 GMT, AgentX@apocalyp se.com wrote:

Yes. Check out "Conditiona l Formatting" in the help file.
Access 2000 and up.

-Tom.
[color=blue]
>Is it possible, In a datasheet view subform, to change the backgound
>color based on the value in a particular field? For example if the
>field is Yes/No, have the background color red for No and Green for
>Yes?
>Any help is greatly appreciated[/color]