Microsoft Access VBA - allocate a colour

Hi - I need to allocate a colour to each person in my database. It is an Access database with a SQL Server back end.

As I add each new contact to the database, I want to randomly allocate a valid colour to them which will then be stored in the contact table.

So how do I randomly allocate a colour, and how would I store that colour, and then display that colour in a field on that person's contact details form please?

It doesn't matter if the colour doesn't look great, because I will give the admin function them ability to edit that colour.