Reference > Functions reference > Text formatting functions > RGB

RGB

Returns an integer number from 0 to 16777215, obtained by combining color values for red, green, and blue.

Format

RGB(red;green;blue)

Parameters

red - any numeric expression or numeric field containing a value from 0 to 255

green - any numeric expression or numeric field containing a value from 0 to 255

blue - any numeric expression or numeric field containing a value from 0 to 255

Data type returned

number

Originated in

FileMaker Pro 7.0

Description

Numbers returned by this function can be passed as the color parameter in the TextColor or TextColorRemove functions. The RGB function uses the following formula to calculate the result:

red * 256² + green * 256 + blue

where 256² = 65536

Tip To determine the RGB value of a color, in Layout mode, click the Fill color palette in the formatting bar and choose Other Color. Values are shown for each of the basic colors. In macOS, select the Color Sliders tab. Choose RGB Sliders from the list.

Example 1

RGB(255;0;0) returns 16711680 representing red.

RGB(0;255;0) returns 65280 representing green.

RGB(0;0;255) returns 255 representing blue.

RGB(0;0;0) returns 0 representing black.

RGB(255;255;255) returns 16777215 representing white.

Example 2

Using a table with text fields FirstName and LastName, specify the following auto-enter calculation for a third field called FullName that displays FirstName in orange and LastName in purple:

TextColor(FirstName;RGB(255;165;0)) &" "& TextColor(LastName;RGB(160;32;240))

RGB