Background Color Cells in Table

[windmag]

A user who is accustomed to formatting individual cells by color in Excel wants to know if this can be done in an Access Table. I've never needed to do this but don't think you can. It is not conditional format. Only at user's discretion. Any advice?

 

[abaldwin]

No, you cant as far as I know. Access tables are meant to store data basically. Recent version have added some ability to do spell checking, showing related records etc but for what you are looking for,,,,,no

The database table view is (IMHO) no place for an end user to be looking at, manipulating, or adding data. That is what forms are for.

Your basic options would be to create a form and write code for the user to select colors, code to automatically color the fields in a form for their conditions, or better yet, Export the data to excel and let them do as they want.

If after changing data in excel, you want to write it back, you can if they have not messed with the basic structure.

Basically as a rule with Access, (real RDMS's) dont even offer things like forms and reports that is a function of the programming and reporting tools.

Anyway
Tables - Store data

Forms - Allow the user a place to interact (insert, delete, and update data)

Reports - Present data in a user friendly manner to include groupings, totals, sorting, etc, as per the output specs.

Macros / Modules - Allow you to automate task and to repeat task over and over again .

I guess my point is that an end user should NEVER be working inside a table.



Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[TheAceMan1]

How are ya windmag . . .

Using a form [blue]Conditional Formatting[/blue] could be used, however its limited to 4 conditions (3 plus default) per field . . .

[blue]Your Thoughts?[/blue]

See Ya! . . . . . .