saving and recalling colors in DB

Hi there… I’ve created a database for my app.
The database works great (saves and recalls chord shapes - highly graphical and wonderful!)
I’m using SQLlite (actually realsql)
However, I’ve been trying to save colors and recall them.
I’m saving them to a varchar like this



(rs is a recordset. Notecolor(j) is a one dimensional array of color)
doesn’t work (it crashes).
The string contained in rs field is the color. How would I go about transferring the string “&h004298F9” into a color variable?

The quickest way is to push it into a variant and then extract the color value.

Dim v as variant = colorString Dim c as color = v.colorValue

You sir, are officially the bomb! :slight_smile:
Cheers, worked a treat!