Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

ms access training course london - changing font colour table

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training course london - Changing font colour in a table

ms access training course london - Changing font colour in a table

ResolvedVersion Standard

Emily has attended:
Access Introduction course

Changing font colour in a table

Hi

This is quite a straight forward request, but basically all I want to be able to do is change the colour of different individual cells.

I have made a table which has all the information relating to events i am organising. Within it i am using the table to show me what has been booked and what is yet to be sorted. I was hoping to be able to make the particular cell bold or a different colour when it has been completed, when i ahve tried to do this by highlighting the particular cell and then going to format and font it changes the whole table ratehr than the one cell.

Could you please tell me whether or not I can do this.

Thanks

RE: Changing font colour in a table

My first thought about your request is that individual cells in an Access table cannot be indiviually formatted for colour. You can do this in a form, per record using conditional formatting.

If anyone knows any different, please let us know.

Richard

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.