If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Field Properties...
"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 |
#3
|
|||
|
|||
Field Properties...
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 |
#4
|
|||
|
|||
Field Properties...
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 |
#5
|
|||
|
|||
Field Properties...
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 |
#6
|
|||
|
|||
Field Properties...
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 |
#7
|
|||
|
|||
Field Properties...
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] |
#8
|
|||
|
|||
Field Properties...
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. ================================================== ======= |
#9
|
|||
|
|||
Field Properties...
"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) |
#10
|
|||
|
|||
Field Properties...
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 |
Thread Tools | |
Display Modes | |
|
|