access course london - Cell Colours

Resolved · Low Priority · Version Standard

Cell Colours

Judith has attended:
Access Intermediate course
Access Advanced course

by - delegate Judith [3 posts] (2007 Aug 23 Thu, 15:32) Reply

Can I change the background colour of cells (actually entire entries) rather than a whole table?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 2 Tue	Southwark	3	book now	£210	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
Full Schedule: See all 53 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Cell Colours

by - trainer David gold contributer [428 posts] (2007 Sep 5 Wed, 11:04) Reply

Judith,

I do not think that this is possible, changing colour of the cells within a table is not really necessary within access (it is more of an excel thing). If you do want to do this I would suggest creating a report.

Hope this helps
David

· Microsoft Access, an Efficient Database Tool
· Why Do I Need To Use Access?
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Get More Out of MS Access Courses
· Why a Microsoft Access Course Could Change the Way You Do Business

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.