Field Properties...

Is it possible to change the back ground color of a filed in a table
according to its value. I want this to happen when the table is in datasheet
view. I already did it in the form.

Example:
If the value of the field = 1 then the Backgorund color should be red, etc.


Thanks!
Ed

"Ed" wrote in message
...
Is it possible to change the back ground color of a filed in a table
according to its value. I want this to happen when the table is in
datasheet
view. I already did it in the form.

Example:
If the value of the field = 1 then the Backgorund color should be red,
etc.


Thanks!
Ed

No. Tables are for storing data and no more. Anything remotely fancy that
Access allows you to do at table level (such as lookups) should be treated
with caution. Conditional formatting can be done at form level.

Keith.
www.keithwilby.co.uk

Conditional Formatting is not available in tables. But then, you should
never show your user the tables. You should only show them queries, forms
or reports, all of which can do Conditional Formatting.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Ed" wrote in message
...
Is it possible to change the back ground color of a filed in a table
according to its value. I want this to happen when the table is in
datasheet
view. I already did it in the form.

Example:
If the value of the field = 1 then the Backgorund color should be red,
etc.


Thanks!
Ed

Kieth,

I tried to tell them that this was not possible but they needed
'Verification'.

Thanks!!
Ed

"Keith Wilby" wrote:

"Ed" wrote in message
...
Is it possible to change the back ground color of a filed in a table
according to its value. I want this to happen when the table is in
datasheet
view. I already did it in the form.

Example:
If the value of the field = 1 then the Backgorund color should be red,
etc.


Thanks!
Ed

No. Tables are for storing data and no more. Anything remotely fancy that
Access allows you to do at table level (such as lookups) should be treated
with caution. Conditional formatting can be done at form level.

Keith.
www.keithwilby.co.uk

Roger,

Thanks! This is a unique situation. When I was assigned the task of updating
this DB the 'Users' only had a datasheet view of the data, that is why I
created a form for them. But of course they thought they should be able to
see it in the datasheet view with the same formatting as the form.

Anyway, I appreciate the response.
Thanks!
Ed

"Roger Carlson" wrote:

Conditional Formatting is not available in tables. But then, you should
never show your user the tables. You should only show them queries, forms
or reports, all of which can do Conditional Formatting.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Ed" wrote in message
...
Is it possible to change the back ground color of a filed in a table
according to its value. I want this to happen when the table is in
datasheet
view. I already did it in the form.

Example:
If the value of the field = 1 then the Backgorund color should be red,
etc.


Thanks!
Ed

You can display forms in Datasheet View, which looks very much like a table,
but gives you the functions of a form.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Ed" wrote in message
...
Roger,

Thanks! This is a unique situation. When I was assigned the task of
updating
this DB the 'Users' only had a datasheet view of the data, that is why I
created a form for them. But of course they thought they should be able to
see it in the datasheet view with the same formatting as the form.

Anyway, I appreciate the response.
Thanks!
Ed

"Roger Carlson" wrote:

Conditional Formatting is not available in tables. But then, you should
never show your user the tables. You should only show them queries,
forms
or reports, all of which can do Conditional Formatting.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Ed" wrote in message
...
Is it possible to change the back ground color of a filed in a table
according to its value. I want this to happen when the table is in
datasheet
view. I already did it in the form.

Example:
If the value of the field = 1 then the Backgorund color should be red,
etc.


Thanks!
Ed

On Thu, 16 Oct 2008 06:44:21 -0700, Ed wrote:

Roger,

Thanks! This is a unique situation. When I was assigned the task of updating
this DB the 'Users' only had a datasheet view of the data, that is why I
created a form for them. But of course they thought they should be able to
see it in the datasheet view with the same formatting as the form.

Table datasheet view is simply inappropriate for this use. You *just can't do
what you ask*.

What you CAN do is give the users a Form which is either a Datasheet form, or
(even better) a Continuous Form tricked up to look just like a datasheet.

It is not important that the users see the Table. In fact they shouldn't!

It *is* important that the users see the *information in the table*, in a way
tha communicates and is useful to them. Tables are for data storage; Forms are
for data display and interaction. Tables should be kept "under the hood", or
behind the panel with the big label "No User Servicable Parts Inside - Opening
Panel Will Void Warrenty".
--

John W. Vinson [MVP]

Hi Ed,

This is Mark, from Microsoft. I'm glad to assist you with the issue.

After reviewing the responces to you from MVP, I would like to do a summary
for you.

Based on your description, you would like to change the back ground color
of a filed in a table in order to let the
"users" see the datasheet view with the sae formatting as the form.

The situation
===============
Tables are for storing data. it is not allowed to change back ground color
of a filed in a table.

Suggestion
===============
1 to address your concern, it is better to display forms in datasheet view.

2 Considering security, it is not suggested to let the "users" to see the
table directly. Since tables are for data storage, users should get the
information from underlying table by form, query and so on.

Hope the above explanation address your concern.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

"Mark Han[MSFT]" wrote in message
...

This is Mark, from Microsoft. I'm glad to assist you with the issue.

After reviewing the responces to you from MVP, I would like to do a
summary
for you.


It's so nice to be appreciated by an MS employee.

Keith (non-MVP)

Hi Ed,,

This is Mark. I'm writing to follow the issue.

If I can assist you anything related to the issue, please tell me.

I look forward to your update. Thanks

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and