change the background color of a cell in access 2010

Discussion in 'Access General' started by Martin ©¿©¬, Oct 6, 2013.

  1. 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
     
    Martin ©¿©¬, Oct 6, 2013
    #1
    1. Advertisements

  2. 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
     
    John W. Vinson, Oct 7, 2013
    #2
    1. Advertisements

  3. 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
     
    Martin ©¿©¬, Oct 7, 2013
    #3
  4. 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
     
    John W. Vinson, Oct 8, 2013
    #4
  5. Thank you again John
     
    Martin ©¿©¬, Oct 10, 2013
    #5
  6. Hi John,
    Forgot to say I got the book Access 2010'Step-by-Step' to help me
     
    Martin ©¿©¬, Oct 10, 2013
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.