define column field colours

[MrWilson]

Hi
i have a view that has two fields in one column, i would like to give each field its own colour, but can only seem to change the colours by column and not the field!.
can you help please.
thanks Mrwilson

 

[pmonett]

This directly from Designer Help :

[b]Setting column colors programmatically[/b]

In Notes client applications, you can set a column's background color and text color programmatically by selecting the "Use value as color" option on the Info tab of the Column Properties box and then supplying RGB coordinates in the Programmer's pane as the value for the column.

[b]Note[/b]  This feature is not supported on the Web.

If you specify one set of coordinates (three numbers separated by colons), the color defines the appearance of the text. If you specify two sets of coordinates (six numbers separated by colons), the first set of coordinates defines the background color for the column, and the second set of coordinates specifies the text color. The color affects the column where you set the color value and all columns to the right of that until another color is set.

[b]Note[/b]  Setting colors to -1:-1:-1 reverts to the view and column properties.

For example, the following formula example shows how RGB coordinates can be used in both single and paired sets.

red := 255:0:0;
blue := 0:0:255;
yellow := 255:255:0;
pink := 255:193:253;
white := 255:255:255;
black :=  1:1:1;
apricot := 255:155:133;
plain:= 0:0:0;

@If (category = "cats";blue:red ;subcategory = "collars";pink;subcategory  ="leashes";black:plain;0:0:0);

 

[MrWilson]

Thanks, but i can not find (Use value as color" option on the Info tab of the Column Properties box )the tabs i see are Basics, Sorting, az, 21, dates, title and hat.
i can not find "use value as color" any where. what am i doing wrong??

 

[pmonett]

What version of Notes are you using ?

Pascal.

 

[MrWilson]

version 4.6.7

 

[pmonett]

Well that explains it. Changeable column colors do not exist for R4. You can only set them in Design.

Pascal.