Functions Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Aggregate functions
- Chapter 3 Date functions
- Chapter 4 Design functions
- Chapter 5 External functions
- Chapter 6 Financial functions
- Chapter 7 Get functions
- Get(AccountName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentHostTimestamp)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(ErrorCaptureState)
- Get(ExtendedPrivileges)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- 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(PortalRowNumber)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(PrivilegeSetName)
- 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(TextRulerVisible)
- Get(TotalRecordCount)
- 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)
- Chapter 8 Logical functions
- Chapter 9 Number functions
- Chapter 10 Repeating functions
- Chapter 11 Summary functions
- Chapter 12 Text functions
- 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
- Chapter 13 Text formatting functions
- Chapter 14 Time functions
- Chapter 15 Timestamp functions
- Chapter 16 Trigonometric functions
- Appendix A Glossary
Chapter 13
|
Text formatting functions 191
Chapter 13
Text formatting functions
Text formatting functions can be used to change the color, font, size, and style of the
specified text. For example, you could use the TextFont function to change the font of
the specified text from Arial to Courier.
Text formatting functions operate on these parameters:
• fields of type text
•text constants (in quotes)
• expressions having a text result
Click a function name for details.
This function Returns
RGB, page 192 A number obtained by combining the red, green, and blue values to represent a
color.
TextColor, page 192 The color of text to the color specified by the RGB function.
TextColorRemove,
page 193
Text with the font colors reverted to the default font color for the field.
TextFont, page 194 Text in the specified font and character set.
TextFontRemove,
page 195
Text with the fonts reverted to the default font for the field.
TextFormatRemove,
page 196
Text with the formatting reverted to the default text format for the field.
TextSize, page 197 Text in the specified font size.
TextSizeRemove,
page 197
Text with the font sizes reverted to the default font size for the field.
TextStyleAdd, page
198
Text with the specified styles added in a single action.
TextStyleRemove,
page 199
Text with the specified styles removed in a single action.