I'm using production mapping and I want to automate the colour of the text inside a table based on the status field. unfortunately I'm not overly familiar with VB. When I enter:
"<CLR red = '255' green = '0' blue= '0'>" &[NAME]& "</CLR>"
it turns my text red which is what it's supposed to do. But I want to use a if then loop to change certain status' to specific colours. below is what I have so far:
if [STATUS] = Available then
"<CLR red = '255' green = '0' blue= '0'>" &[NAME]& "</CLR>"
elseif [STATUS] = Vacation then
"<CLR red = '0' green = '255' blue= '0'>" &[NAME]& "</CLR>"
else
"<CLR red = '0' green = '0' blue= '0'>" &[NAME]& "</CLR>"
end if
Aucun commentaire:
Enregistrer un commentaire