Formatting table colors on Access

[Srin]

1. Can we have the cells within access table change color when their input changes as in excel? For Ex:

If the input for a cell inside Column "Status" says "Pending" then the cell color is orange.


If it says "Completed" then color is green?

Is this possible on Access?

2. Also is it possible to change the color of Column headings?

I tried changing the color but found that the entire table changed colors with alternate rows.

[JeroenMioch]

I dont think its possible in datasheet view.
However, if you view your data through a form you can do practicly everything you want including conditional formatting.

[Srin]

Hi JeroenMioch,

Can I view the entire table in form view. And if I decide to do that, how can I do it?

[June7]

Build a form and bind it to table or query. Use Conditional Formatting of textbox and combobox.

[Srin]

Hi June7,
Could you please explain on that. What kind of form would enable me to do this and how do I bind it to the table.

[June7]

Any kind of form. Set form's RecordSource property. This is basic Access functionality.

Perhaps you should complete a tutorial on web or in book. http://www.rogersaccesslibrary.com/

[JeroenMioch]

A table is like an excel sheet except it holds the rows together when sorting. Thats one reason why we use Access and
not Excel.
A form is like a window from where you look at this table with data.
The form is highly customisable, basicly you can do anything you wish to the data your viewing through it.
Like June said you have to link the two together. So you tell the form wich data (table) is bound to it.

Once you have done that you can format a control (form) to change colour when the underlaying data in the field (table) holds a specific value. For example if the value in the field is greater then 1000 the background of the control turns red. If the value is between 1001 and 2000 it turns green etc etc.
This can be done using conditional formatting on the control, or programaticly using Visual Basic for Applications (VBA).

To explain more then the above would take a LOT of time so like June said you better read up on the basics of Access and VBA coding.

[Srin]

Thank you June7 and JeroenMioch. I was able to figure it out using Forms and binding the required table to the form using RecordSource property and then using Conditional Formatting.