change the background color of a cell in access 2010

[Martin ©¿©¬]

Hi,
I have just started creating a database for a community oil club
How do I change the background color of a cell in access 2010
Any other usefull tips/help would be appreciated
Thank you

 

[John W. Vinson]

Hi,
I have just started creating a database for a community oil club
How do I change the background color of a cell in access 2010
Any other usefull tips/help would be appreciated
Thank you

Since Access databases do not have "cells" the question is vacuous.

I suspect you're trying to work directly in table datasheets. DON'T! Tables
may look like spreadsheets but they are emphatically NOT.

You'll need Tables to store data (under the hood, out of user view); Queries
to combine and arrange data; Forms to display, enter, and edit data into the
tables; Reports to print that data; and Macros and VBA code to enhance the
forms and reports.

Here are some resources to help you get started. Crystal's and Roger's
tutorials would be particularly worth investigating.

Utter Access discussion forum and resources:
http://www.utteraccess.com

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Martin ©¿©¬]

Thank you John for all the helpful information,
This will be a great help. I am learning to create tables at present &
hopefully moving on to Queries, Forms, Reports & Relationships.
So the learning curve begins

 

[John W. Vinson]

Thank you John for all the helpful information,
This will be a great help. I am learning to create tables at present &
hopefully moving on to Queries, Forms, Reports & Relationships.
So the learning curve begins

Good luck!

Note that you can't change the color of a field in a table datasheet, but it's
very easy to do so (several ways in fact) to change the background color of a
Textbox on a Form - which is one reason you should use forms for data
interaction.

The learning curve can be steep and rocky but the references should help. Bear
in mind that this Usenet newsgroup is "dead" as far as Microsoft is concerned;
the sites in my .sig will get a lot more traffic and attention.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Martin ©¿©¬]

Good luck!

Note that you can't change the color of a field in a table datasheet, but it's
very easy to do so (several ways in fact) to change the background color of a
Textbox on a Form - which is one reason you should use forms for data
interaction.

The learning curve can be steep and rocky but the references should help. Bear
in mind that this Usenet newsgroup is "dead" as far as Microsoft is concerned;
the sites in my .sig will get a lot more traffic and attention.

Thank you again John

 

[Martin ©¿©¬]

Good luck!

Note that you can't change the color of a field in a table datasheet, but it's
very easy to do so (several ways in fact) to change the background color of a
Textbox on a Form - which is one reason you should use forms for data
interaction.

The learning curve can be steep and rocky but the references should help. Bear
in mind that this Usenet newsgroup is "dead" as far as Microsoft is concerned;
the sites in my .sig will get a lot more traffic and attention.

Hi John,
Forgot to say I got the book Access 2010'Step-by-Step' to help me