Forum Home
Press F1
Thread ID: 79873	2007-06-04 04:24:00	Change font color for selected columns in Access	Chemical Ali (118)	Press F1

Post ID	Timestamp	Content	User
555997	2007-06-04 04:24:00	Hi I've got a database in Microsoft Access that holds all of our CD titles. What I was wanting to be able to do is change the font colour of only some of the rows (record fields) on the table/datasheet but NOT all of them which is all I can seem to do when i go Format - Font. Anyone know how to do this? Cheers	Chemical Ali (118)
555998	2007-06-04 04:37:00	I don't know about Access but I know that you can do that in Excell. Are your catalogued CDs not loaded on your computer?	winmacguy (3367)
555999	2007-06-04 05:00:00	Yes they (the CDs) are ripped to the PC - it's more for when the kids want to pick & play one of their CDs -- wanted to have their CD record fields highlighted in a different colour so making it easier fro them to find.	Chemical Ali (118)
556000	2007-06-04 05:05:00	Would it not be easier just to make a play list for the kids with all their favourites in a folder in something like iTunes? That is how I have my collection of 3000 songs plus a few videos set up. Doing it in Access would be more complicated that having teeth pulled minus the anesthetic.	winmacguy (3367)
556001	2007-06-04 06:37:00	Dude You ain't reading and/or comprehending me right?! They (the kids) use teh access database to pick a (physical) CD to go and play in a CD/DVD player. (:	Chemical Ali (118)
556002	2007-06-04 07:36:00	Dude You ain't reading and/or comprehending me right?! They (the kids) use teh access database to pick a (physical) CD to go and play in a CD/DVD player. (: Ah I get you now. I have never heard of anyone doing that. Sounds like a very inefficient way of selecting their CDs. How many CDs do you own? Most people I know who have more than 50 CDs just do a visual scan down their CD rack and pick out the one they want based on the name on the cover(unless you have downloaded them from Limewire or something and don't have CD covers. I use iTunes, much easier, just have your PC plugged into your amplifier. To answer your initial question, have you tried looking in the Access Help section.? I don't use access so I am not very familiar with it. I have used Excell for database stuff though as it has a very good sort function.	winmacguy (3367)
556003	2007-06-04 07:51:00	Have you checked to see if you can highlight the relevant cell in Access, rather than the text within the cell?	winmacguy (3367)
556004	2007-06-05 01:51:00	Within a table I'm not sure that you can colour an individual cell. I think it is pretty much all or nothing with Access versions up to 2003 (not sure about Access 2007). As a possible work around could you create another column (make it something like boolean i.e. Yes/No) to indicate whether the cd had been ripped or not. You could then use this column to do sorts/filters according to whether the CDs have been ripped or not.	odyssey (4613)
556005	2007-06-05 05:08:00	Yes they (the CDs) are ripped to the PC - it's more for when the kids want to pick & play one of their CDs -- wanted to have their CD record fields highlighted in a different colour so making it easier fro them to find. Why do you need to have the CD titles in Access? Most decent music playing software has a built in database that negates the requirement for Access.	winmacguy (3367)
556006	2007-06-10 11:05:00	Hi What you have described can't be done in an Access table. But it can be done in an Access form (or report), where the form is based on the table. There is a conditional formatting option under (forms) menu option Format > Conditional Formatting. But this is only for a single field - where you want to colour an entire row on the form then you will need to use VBA. Andrew P.S. But that said - if you include a 'CD owner' field then you can sort and/or filter on that field (to make it easier to find CD titles) by using the various tools available under the right-click menu options.	andrew93 (249)
1