# Convert string to colour

**URL:** <https://forum.xojo.com/t/convert-string-to-colour/35697>\
**Category:** Getting Started\
**Created:** [January 24, 2017, 8:45pm UTC](https://forum.xojo.com/t/convert-string-to-colour/35697 "2017-01-24T20:45:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nathan\_Wright](https://forum.xojo.com/user_avatar/forum.xojo.com/nathan_wright/32/575_2.png) [@Nathan\_Wright](https://forum.xojo.com/u/Nathan_Wright)\
**Post date:** [January 24, 2017, 8:45pm UTC](https://forum.xojo.com/t/convert-string-to-colour/35697/1 "2017-01-24T20:45:48Z")

</div>

I have a database and in one of the fields I hold a string e.g. “#AABAF3” and I need to convert this into a colour that I can use in Xojo as a color type e.g. &cAABAF3

I have checked the docs but can’t seem to find how to do this.

---

<div class="post-metadata">

**Author:** ![Jean-Yves\_Pochez](https://forum.xojo.com/user_avatar/forum.xojo.com/jean-yves_pochez/32/21769_2.png) [@Jean-Yves\_Pochez](https://forum.xojo.com/u/Jean-Yves_Pochez)\
**Post date:** [January 24, 2017, 8:51pm UTC](https://forum.xojo.com/t/convert-string-to-colour/35697/2 "2017-01-24T20:51:43Z")

</div>

[code]Public Function ToColor(extends ColorString As String) as Color  
Dim v As Variant = ColorString  
Dim c As Color = v.ColorValue  
Return c

End Function  
[/code]

---

<div class="post-metadata">

**Author:** ![Jeremie\_L](https://forum.xojo.com/user_avatar/forum.xojo.com/jeremie_l/32/150_2.png) [@Jeremie\_L](https://forum.xojo.com/u/Jeremie_L)\
**Post date:** [January 24, 2017, 8:59pm UTC](https://forum.xojo.com/t/convert-string-to-colour/35697/3 "2017-01-24T20:59:29Z")

</div>

[code]Public Function ToColor(extends ColorString As String) as Color  
Dim v As Variant = ColorString.Replace("#", “&c”)  
Dim c As Color = v.ColorValue  
Return c

End Function[/code]

---

<div class="post-metadata">

**Author:** ![Nathan\_Wright](https://forum.xojo.com/user_avatar/forum.xojo.com/nathan_wright/32/575_2.png) [@Nathan\_Wright](https://forum.xojo.com/u/Nathan_Wright)\
**Post date:** [January 24, 2017, 9:05pm UTC](https://forum.xojo.com/t/convert-string-to-colour/35697/4 "2017-01-24T21:05:22Z")

</div>

Thanks guys

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [October 29, 2020, 6:37pm UTC](https://forum.xojo.com/t/convert-string-to-colour/35697/5 "2020-10-29T18:37:39Z")

</div>