VBA read colors from file

[luckydead21]

Hello, can someone help me how to make this in MS access VBA code to read from .txt file the colors

Example: Let's say my file name is called "Colors.txt"
Inside of it i have this information:

"W" = RGB(255,255,255)
"B" = RGB(0,0,0)
and so one..
And inside my access file i have table where it reads item color so i type there for example "B"
and when execute the fetch it will read "B" color from .txt file and display the color

Can someone help me to build such function or code?
Thanks


EDIT:
For now i use in VBA with Case
If case = "B" then do something
case = "W/B" then do something and so one

 

[luckydead21]

example the best idea i got in my mind is to read only the information from the file
in my file Colors.txt i have input this codes:

Select Case Col1.Text
Case "B"
    color1_1.BackColor = RGB(0, 0, 0)
    color1_2.Visible = False

Case "B/BR"
    color1_1.BackColor = RGB(0, 0, 0)
    color1_2.Visible = True
    color1_2.BackColor = RGB(128, 64, 0)
End Select

How to make to read the entire file information like its writed in the .txt file not to be in single string or line. To read all lines the same as are in .txt ? maybe this can solve my issues faster