Functions Reference
Table Of Contents
- Contents
- About functions
- Functions reference (alphabetical list)
- Aggregate functions
- Date functions
- Design functions
- External functions
- Financial functions
- Get functions
- Get(AccountExtendedPrivileges)
- Get(AccountName)
- Get(AccountPrivilegeSetName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActivePortalRowNumber)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentExtendedPrivileges)
- Get(CurrentHostTimestamp)
- Get(CurrentPrivilegeSetName)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(DocumentsPathListing)
- Get(ErrorCaptureState)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostApplicationVersion)
- Get(HostIPAddress)
- Get(HostName)
- Get(LastError)
- Get(LastMessageChoice)
- Get(LastODBCError)
- Get(LayoutAccess)
- Get(LayoutCount)
- Get(LayoutName)
- Get(LayoutNumber)
- Get(LayoutTableName)
- Get(LayoutViewState)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(PageNumber)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(QuickFindText)
- Get(RecordAccess)
- Get(RecordID)
- Get(RecordModificationCount)
- Get(RecordNumber)
- Get(RecordOpenCount)
- Get(RecordOpenState)
- Get(RequestCount)
- Get(RequestOmitState)
- Get(ScreenDepth)
- Get(ScreenHeight)
- Get(ScreenWidth)
- Get(ScriptName)
- Get(ScriptParameter)
- Get(ScriptResult)
- Get(SortState)
- Get(StatusAreaState)
- Get(SystemDrive)
- Get(SystemIPAddress)
- Get(SystemLanguage)
- Get(SystemNICAddress)
- Get(SystemPlatform)
- Get(SystemVersion)
- Get(TemporaryPath)
- Get(TextRulerVisible)
- Get(TotalRecordCount)
- Get(TriggerKeystroke)
- Get(TriggerModifierKeys)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- Logical functions
- Number functions
- Repeating functions
- Summary functions
- Text functions
- Char
- Code
- Exact
- Filter
- FilterValues
- GetAsCSS
- GetAsDate
- GetAsNumber
- GetAsSVG
- GetAsText
- GetAsTime
- GetAsTimestamp
- GetAsURLEncoded
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- Quote
- Replace
- Right
- RightValues
- RightWords
- RomanHankaku
- RomanZenkaku
- SerialIncrement
- Substitute
- Trim
- TrimAll
- Upper
- ValueCount
- WordCount
- Text formatting functions
- Time functions
- Timestamp functions
- Trigonometric functions
FILEMAKER FUNCTIONS REFERENCE 232
Originated in
FileMaker Pro 7.0
Description
Use this function to change the color of text.
Note Text formatting options will be lost if the field type that is returned is something other than text.
Tip To determine the RGB value of a color:
• (Windows) 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.
• (Mac OS) Start the DigitalColor Meter application in the Applications/Utilities folder. Choose
RGB As Actual Value, 8-bit. Move the pointer over colors onscreen to see their values.
Examples
TextColor(“Plaid”;RGB(255;0;0)) returns the word Plaid in red.
TextColor(“Plaid”;RGB(0;255;0)) returns the word Plaid in green.
TextColor(“Plaid”;RGB(0;0;255)) returns the word Plaid in blue.
TextColor(“Plaid”;RGB(0;0;0)) returns the word Plaid in black.
TextSize( TextFont( TextColor( MyTable::MyText; RGB( 0 ; 125 ; 125 ) );
"Courier" ) ; 12)
returns the text contained in MyTable::MyText formatted as 12pt. green text
with the Courier font.
Related topics
Contents
Functions reference (alphabetical list)
TextColorRemove
Purpose
Removes all font colors in text, or removes the font color specified by the RGB function.
Format
TextColorRemove(text{;RGB(red;green;blue)})
Parameters
text - any text expression or text field.
RGB(red;green;blue) - any integer number from 0 to 16777215 obtained by combining the red,
green, and blue values (each ranging from 0 to 255) to represent a color.
Parameters in curly braces { } are optional.
Data type returned
text