Different Color Each Row - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Different Color Each Row

Ian Sager

6 years ago

Good afternoon Richard
I wonder if you could help me with, what I hope, will be a simple answer.

I have a table where one of the fields is called 'colourcode' and contains a hexadecimal number representing a specific colour.

What I would like to do is, on a form, where that field is represented on each row, instead of showing the hexadecimal number as text
I would like the back colour of that box to use the hex number to set its colour. I hope I have made myself clear with this description.

Many Thanks in anticipation
Kindest of regards,
Ian
PS I am just about to finish Access beginner level 9 and have thoroughly enjoyed the courses.

	Richard Rost @Reply 6 years ago
Can't do it in a Continuous Form. You can do it in a Single Form. In fact, I show how to do it in a few classes, like Advanced 3. The only color options you have to change the color in a Continuous Form is with Conditional Formatting. Once you change a color property it affects ALL of that object on the form.

	Richard Rost @Reply 6 years ago
Ian, I moved your post here to the Access Forum instead of the Contact Me page. This is so you get the email notification.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View