|
|
Property, Method and Event Reference
Thank you for your interest in Total Access Memo. This page lists every Property, Method, Event, and Constant available in the Total Access Memo control.
AboutBox Method
| Applies To | Total Access Memo |
| Description | Shows the about box for FMS Total Access Memo |
| Syntax | fmsmemo.AboutBox |
Add Method
| Applies To | OLEObjects | |
| Description | Adds an object to the control | |
| Syntax | fmsmemo.Add([Index], [source], [objclass]) | |
| Parameters | Description | |
| Index | This sets the index of the object you are adding. This is optional. | |
| Key | This parameter is not used in Total Access Memo; it is provided for compatibility with the Microsoft RichText Control only. This is optional. | |
| source | This sets the filename of a document to insert into the control. This is optional. | |
| objclass | This sets the class name of the object to insert. This is optional. | |
| Remarks | You must specify either a valid source or objclass parameter when calling this method. The Add method fails if one of these parameters is not set. | |
Appearance Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the three dimensional effect of the control. | |
| Setting | Setting | Description |
| rtfFlat | The control displays with a flat appearance. | |
| rtfThreeD | The control displays with a three dimensional appearance. | |
| Remarks | The Appearance property is included for compatibility with the Microsoft RTF control. To change the Appearance of the Memo control, you should use the built-in Microsoft Access properties. | |
AutoVerbMenu Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets a value indicating if the verb menu is displayed. | ||
| Setting | Setting | Description | VBA |
| Yes | The verb menu is enabled. | True | |
| No | The verb menu is disabled. | False | |
| Remarks | If this property is set to True, the verb menu is displayed when the user right clicks on the control. | ||
BackColor Property
| Applies To | Total Access Memo |
| Description | Returns or sets the color for the interior of a control. |
| Setting | Accepts and returns long values. |
Bold Property
| Applies To | Font | |
| Description | Returns or sets the bold style of the font. | |
| Setting | Description | VBA |
| The selection is bold. | True | |
| The selection is not bold. | False | |
BorderStyle Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the type of border for the control. | |
| Setting | Setting | Description |
| rtfNoBorder | No border is displayed. | |
| rtfFixedSingle | A single line is displayed for the border. | |
| Remarks | The BorderStyle property is included for compatibility with the Microsoft RTF control. To change the BorderStyle of the Memo control, you should use the built-in Microsoft Access properties. | |
BulletIndent Property
| Applies To | Total Access Memo |
| Description | Returns or sets the default indentation for bullet points, in twips. |
| Setting | Accepts and returns integers. |
Change Event
| Applies To | Total Access Memo |
| Description | Occurs when the user changes the value of the control. |
| Syntax | Sub fmsmemo_Change () |
| Remarks | This event does not fire if the Value property is changed through code. |
CharSet Property
| Applies To | Font | |
| Description | Returns or sets the character set of the font. | |
| Setting | Description | VBA |
| Standard Windows characters | 0 | |
| The symbol character set, including Wingdings and other symbol fonts. | 2 | |
| A character set unique to the Japanese version of Windows. | 128 | |
| Extended characters normally displayed by DOS applications. | 255 | |
| Remarks | This property is not available in Access’s property pages. | |
Class Property
| Applies To | OLEObject |
| Description | Returns the class name of the object. |
| Setting | Returns string values. |
Clear Method
| Applies To | OLEObjects |
| Description | Removes all objects from the OLEObjects collection. |
| Syntax | fmsmemo.OLEObjects.Clear |
Click Event
| Applies To | Total Access Memo |
| Description | Occurs when the user clicks in the control. |
| Syntax | Sub fmsmemo_Click() |
CloseEditor Method
| Applies To | Total Access Memo | |
| Description | Closes the editor. | |
| Syntax | fmsmemo.CloseEditor(fKeepChanges) | |
| Parameter | Description | |
| fKeepChanges | True saves changes made in the editor into the control. | |
| Remarks | The EditorClose event is not fired when this method is used to close the editor. | |
Count Property
| Applies To | OLEObjects |
| Description | Returns the count of the OLEObject objects in this collection. |
| Setting | Returns integer values. |
DataChanged Property
| Applies To | Total Access Memo | ||
| Description | Returns a value indicating if the data in the control has changed. | ||
| Setting | Setting | Description | VBA |
| Yes | The data in the control has changed. | True | |
| No | The data in the control has not changed. | False | |
| Remarks | The DataChanged property is kept for backwards compatibility only, and therefore does not return a reliable value. | ||
DblClick Event
| Applies To | Total Access Memo |
| Description | Occurs when the user double clicks in the control. |
| Syntax | Sub fmsmemo_DblClick() |
DisableNoScroll Property
| Applies To | Total Access Memo |
| Description | This property is obsolete, and is only kept for compatibility with the Microsoft RTF control. Setting this property has no effect on the Total Access Memo control. |
DisplayType Property
| Applies To | OLEObject | |
| Description | Returns or sets the display style of the object. | |
| Setting | Description | VBA |
| The object displays its contents. | rtfDisplayContent | |
| The object displays an iconic representation of itself. | rtfDisplayIcon | |
DoVerb Method
| Applies To | OLEObject | |
| Description | Invokes the specified verb on the object. | |
| Syntax | fmsmemo.OLEObjects(Index.)DoVerb(Verb) | |
| Parameter | Description | |
| Verb | This parameter sets the verb to invoke and can have one of these values: | |
| Description | VBA | |
| Sets the verb to the default. | rtfOLEPrimary | |
| Opens the object. | rtfOLEShow | |
| Opens the object in a separate window. | rtfOLEOpen | |
| Hides the application that created the object. | rtfOLEHide | |
| Activates the object. | rtfOLEUIActivate | |
| In Place activates the object. | rtfOLEInPlaceActivate | |
| Causes the object to disregard undo information. | rtfOLEDiscardUndoState | |
Echo Property
| Applies To | Total Access Memo | ||
| Description | Determines if screen updating is turned on. | ||
| Setting | Setting | Description | VBA |
| Yes | The control updates the screen. | True | |
| No | The control does not update the screen. | False | |
EditorClose Event
| Applies To | Total Access Memo | |
| Description | Fires when the editor closes. | |
| Syntax | Sub fmsmemo_EditorClose(fKeepChanges As Boolean) | |
| Argument | Description | |
| fKeepChanges | This indicates if the changes in the editor are saved to the control. | |
EditorEnabled Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets a value indicating if the editor is enabled. | ||
| Setting | Setting | Description | VBA |
| Yes | The editor is enabled. | True | |
| No | The editor is disabled. | False | |
| Remarks | Setting this property to False prevents the user from opening the editor. This property is not supported in reports. | ||
EditorOpen Event
| Applies To | Total Access Memo |
| Description | Fires when the editor opens. |
| Syntax | Sub fmsmemo_EditorOpen() |
| Remarks | This event is not supported in reports. |
EditorTitle Property
| Applies To | Total Access Memo |
| Description | Returns or sets the text displayed in the caption bar of the editor. |
| Setting | Accepts and returns strings. |
| Remarks | This property is not supported in reports. |
Enabled Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets a value indicating if the control is enabled. | ||
| Setting | Setting | Description | VBA |
| Yes | The control is enabled. | True | |
| No | The control is disabled. | False | |
| Remarks | You must close and re-open the form before this property takes effect. This property conflicts
with a built in Access property, so when setting it in code, you must use the syntax fmsmemo.Object.Enabled. Please note that setting this property to false in Access’s property pages is not supported due to Access’s behavior with ActiveX controls. To set this property, use Total Access Memo’s custom property pages or set it in code using the syntax above. |
||
FetchVerbs Method
| Applies To | OLEObject |
| Description | Updates the list of verbs the object supports. |
| Syntax | fmsmemo.OLEObjects(Index.)FetchVerbs |
| Remarks | You must call this method before referring to the following properties: ObjectVerbFlags, OjbectVerbs, ObjectVerbsCount. |
FileName Property
| Applies To | Total Access Memo |
| Description | Returns or sets the filename of the file loaded into the control. |
| Setting | Accepts and returns strings. |
| Remarks | Setting this property loads the text from the file into the control. Setting this property has the same effect as calling the LoadFile method. |
Find Method
| Applies To | Total Access Memo | |
| Description | Finds text in the control. | |
| Syntax | long = fmsmemo.Find (bstrString, [vStart], [vEnd], [vOptions]) | |
| Parameter | Description | |
| bstrString | The string expression to find. | |
| vStart | The starting position to begin the search. This is optional. | |
| vEnd | The ending position to stop the search. This is optional. | |
| vOptions | The options to use in the search. Setting this is optional. | |
| Description | VBA | |
| Find whole words. | rtfWholeWord | |
| Match the case of bstrString. | rtfMatchCase | |
| Do not highlight a word when it is found. | rtfNoHighlight | |
| Remarks | This method returns the first character position of the text, or -1 if the text is not found. | |
FindReplace Method
| Applies To | Total Access Memo | |
| Description | Finds and replaces text in the control. | |
| Syntax | fmsmemo.FindReplace (bstrFind, bstrReplace, [vStart], [vEnd], [vOptions]) | |
| Parameter | Description | |
| bstrFind | The string expression to find. | |
| bstrReplace | The string expression used as the replacement text. | |
| vStart | The starting position to begin the search. This is optional. | |
| vEnd | The ending position to stop the search. This is optional. | |
| vOptions | The options to use in the search. Setting this is optional. | |
| Description | VBA | |
| Find whole words. | rtfWholeWord | |
| Match the case of bstrString. | rtfMatchCase | |
FixedRightMargin Property
| Applies To | Total Access Memo | |
| Description | Returns or sets a value indicating if the right margin in the editor is fixed to the width of the control. | |
| Setting | Description | VBA |
| The right margin of the editor is fixed to the width of the control. | True | |
| The right margin of the editor is fixed to the width of the editor. | False | |
Font Property
| Applies To | Total Access Memo | |
| Description | Determines the default font used in the control. | |
| Setting | Returns or sets an object. | |
| Properties | Name | Description |
| Bold | Determines if the font is bold. | |
| Charset | Determines the character set of the font. | |
| Italic | Determines if the font is italicized. | |
| Name | Determines the name of the font. | |
| Size | Determines the size of the font. | |
| StrikeThrough | Determines if the font has a line drawn through it. | |
| Underline | Determines if the font is underlined. | |
| Weight | Determines the weight of the font. | |
| Remarks | This property is an object containing properties of its own. Refer to the properties of the font by using the VBA settings listed (e.g. Font.Bold). | |
ForeColor Property
| Applies To | Total Access Memo |
| Description | Returns or sets the color for the Foreground of a control. |
| Setting | Contains a long value that corresponds to the foreground color. |
GetCharFromPos Method
| Applies To | Total Access Memo | |
| Description | Returns the character position at the specified coordinate. | |
| Syntax | long = fmsmemo.GetCharFromPos(x, y) | |
| Parameter | Description | |
| x | This determines the x coordinate, in twips. | |
| y | This determines the y coordinate, in twips. | |
GetLineFromChar Method
| Applies To | Total Access Memo | |
| Description | Returns the line number containing the specified character position. | |
| Syntax | long = fmsmemo.GetLineFromChar(lChar) | |
| Parameter | Description | |
| lChar | The character position from where to retrieve the line number. | |
| Remarks | This method returns the actual line number in the control. The number of lines can change when the dimensions of the editing window change. | |
GetPosFromChar Method
| Applies To | Total Access Memo | |
| Description | Returns the coordinate position based on a character position. | |
| Syntax | fmsmemo.GetPosFromChar lChar, x, y | |
| Parameter | Description | |
| lChar | Sets the character position from where to retrieve the line number. | |
| x | The x coordinate, in twips, is returned in this parameter. | |
| y | The y coordinate, in twips, is returned in this parameter. | |
HeightOfText Property
| Applies To | Total Access Memo |
| Description | Returns the height of the text in the control. |
| Setting | Returns long values. |
HideSelection Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets a value indicating if text is highlighted when the control loses focus. | ||
| Setting | Setting | Description | VBA |
| Yes | The selected text is not highlighted when the control loses focus. | True | |
| No | Highlighting stays on the text when the control loses focus. | False | |
Hyperlinks Property
| Applies To | Total Access Memo |
| Description | Returns or sets a value indicating if hyperlinks are enabled. |
| Setting | Returns a Boolean value. |
| Remarks | In the Total Access Memo control, the link event fires when a Hyperlink is clicked. When you click a hyperlink from the editor, the link event does not fire, but rather the hyperlink is automatically opened. Please note that all hyperlinks must be prefaced with one of the following in order to be valid: http://; https://; ftp://; or file:. Also, in order to be valid, a hyperlink cannot contain any spaces. If you set the Hyperlinks property to False, Hyperlinks will not fire the link event in the Total Access Memo control. Hyperlinks will, however, still function in the FMS Rich Editor. |
HWnd Property
| Applies To | Total Access Memo |
| Description | Returns a handle to the control window. |
| Setting | Returns long values. |
Index Property
| Applies To | OLEObjects |
| Description | Returns the index of the object. |
| Setting | Returns integer values. |
InsertObject Property
| Applies To | OLEObjects |
| Description | Invokes the Insert Object dialog, and inserts an object if the user chooses one. |
| Syntax | fmsmemo.OLEObjects.InsertObject |
Italic Property
| Applies To | Font | |
| Description | Returns or sets the italic style of the font. | |
| Syntax | Description | VBA |
| The selection is italicized. | True | |
| The selection is not italicized. | False | |
Item Property
| Applies To | OLEObjects |
| Description | Returns an OLEObject object from the collection by index. |
| Setting | Returns an OLEObject. |
| Remarks | This is a parameterized property, starting with a zero-based index. |
KeyDown Event
| Applies To | Total Access Memo | |
| Description | Occurs when a key is depressed. | |
| Syntax | Sub fmsmemo_KeyDown(KeyCode As Integer, ByVal Shift As Integer) | |
| Argument | Description | |
| KeyCode | This is the code of the depressed key. | |
| Shift | This is the shift state of the keyboard. | |
| Remarks | For more information about using this event in your application, please see the Microsoft Access Help. | |
KeyPress Event
| Applies To | Total Access Memo | |
| Description | Fires when a key is pressed. | |
| Syntax | Sub fmsmemo_KeyPress(KeyAscii As Integer) | |
| Argument | Description | |
| KeyAscii | This specifies the ASCII character code of the key that was pressed. | |
| Remarks | For more information about using this event in your application, please see the Microsoft Access Help. | |
KeyUp Event
| Applies To | Total Access Memo | |
| Description | Fires when a key is released. | |
| Syntax | Sub fmsmemo_KeyUp(KeyCode As Integer, ByVal Shift As Integer) | |
| Argument | Description | |
| KeyCode | This is the code of the released key. | |
| Shift | This is the shift state of the keyboard. | |
| Remarks | For more information about using this event in your application, please see the Microsoft Access Help. | |
Link Event
| Applies To | Total Access Memo | |
| Description | Occurs when a hyperlink is clicked. | |
| Syntax | Sub fmsmemo_Link(strURL As String) | |
| Argument | Description | |
| strURL | This specifies the text of the hyperlink. | |
| Remarks | This event is used to customize what happens when a hyperlink is clicked. See the sample database for an example of this event. | |
LoadFile Method
| Applies To | Total Access Memo | |
| Description | Loads the specified file into the control. | |
| Syntax | fmsmemo.LoadFile(bstrFileName, [vFileType]) | |
| Part | Description | |
| bstrFileName | This specifies the name of the file to load into the control. | |
| vFileType | This specifies the type of the file to load. This parameter is optional. | |
| Description | VBA | |
| The file is loaded as RTF. | rtfRTF | |
| The file is loaded as text. | rtfText | |
| Remarks | If the vFileType parameter is not specified, the control attempts to detect the file type. | |
Locked Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets a value indicating if the user can modify the contents of the control. | ||
| Setting | This property has the following settings: | ||
| Setting | Description | VBA | |
| Yes | The user cannot change the contents of the control. | True | |
| No | The user can change the contents of the control. | False | |
| Remarks | This property is similar to the Enabled property, but differs in a few ways. When the Enabled property is false, the control is locked from all user input. The Locked property only prevents the user from changing the contents of the control. The user may still use the scroll bars and select text. The user may also open the editor and change formatting options. This property conflicts with a built in Access property, so when setting it in code, you must use the syntax fmsmemo.Object.Locked. |
||
MaxLength Property
| Applies To | Total Access Memo |
| Description | Returns or sets the maximum allowed length of text in the control. |
| Setting | Accepts and returns long values. |
| Remarks | Setting this property to zero indicates unlimited length. The MaxLength property will not limit the length of text that is loaded programmatically. If you are loading text programmatically, you should write validation code to check the length of the string. |
MouseDown Event
| Applies To | Total Access Memo | |
| Description | Occurs when a mouse button is pressed. | |
| Syntax | Sub fmsmemo_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Long, ByVal y As Long) | |
| Argument | Description | |
| Button | This specifies the mouse button that was pressed. | |
| Shift | This is the shift state of the keyboard. | |
| x | This is the x position of the mouse. | |
| y | This is the y position of the mouse. | |
| Remarks | For more information about using this event in your application, please see the Microsoft Access Help. | |
MouseIcon Property
| Applies To | Total Access Memo |
| Description | Returns or sets a custom mouse icon. |
| Setting | Accepts and returns a picture. |
| Remarks | The MouseIcon property provides a custom icon that is used when the MousePointer property is set to rtfMouseCustom. This control does not load animated cursor (.ani) files, even though Windows support these cursors. The only supported file types are icons (*.ico) and cursors (*.cur). This property can only be set at design time. Please note that this property is not available in Access’s property pages. |
MouseMove Event
| Applies To | Total Access Memo | |
| Description | Occurs when the mouse moves over the control. | |
| Syntax | Sub fmsmemo_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Long, ByVal y As Long) | |
| Argument | Description | |
| Button | This specifies the state of the mouse buttons. | |
| Shift | This is the shift state of the keyboard. | |
| x | This is the x position of the mouse. | |
| y | This is the y position of the mouse. | |
| Remarks | For more information about using this event in your application, please see the Microsoft Access Help. | |
MousePointer Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets the mouse pointer displayed by the control. | ||
| Setting | Setting | Description | VBA |
| rtfDefault | The default arrow is used. | rtfDefault | |
| rtfArrow | The standard arrow is used. | rtfArrow | |
| rtfCross | Crosshair is used. | rtfCross | |
| rtfMouseCustom | A custom pointer is used. | rtfMouseCustom | |
| rtfIBeam | Text I-beam is used. | rtfIBeam | |
| rtfIcon | This setting is obsolete, and is kept for backwards compatibility only. Setting your MousePointer to rtfIcon displays the standard arrow. | rtfIcon | |
| rtfSize | TSize (four-pointed arrow pointing north, south, east, and west) is used. | rtfSize | |
| rtfSizeNESW | A double-pointed arrow pointing northeast and southwest is used. | rtfSizeNESW | |
| rtfSizeNS | A double-pointed arrow pointing north and south is used. | rtfSizeNS | |
| rtfSizeNWSE | A double-pointed arrow pointing northwest and southeast is used. | rtfSizeNWSE | |
| rtfSizeEW | A double-pointed arrow pointing west and east is used. | rtfSizeEW | |
| rtfUpArrow | A vertical arrow is used. | rtfUpArrow | |
| rtfHourglass | The hourglass is used. | rtfHourglass | |
| rtfNoDrop | A slashed circle is used. | rtfNoDrop | |
| rtfArrowHourglass | The standard arrow with a small hourglass is used. | rtfArrowHourglass | |
| rtfArrowQuestion | The standard Arrow with a Question Mark is used. | rtfArrowQuestion | |
| rtfSizeAll | Size (four-pointed arrow pointing north, south, east, and west) is used. | rtfSizeAll | |
MouseUp Event
| Applies To | Total Access Memo | |
| Description | Occurs when a mouse button is released. | |
| Syntax | Sub fmsmemo_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Long, ByVal y As Long) | |
| Argument | Description | |
| Button | This specifies the mouse button being released. | |
| Shift | This specifies the shift state of the keyboard. | |
| x | This is the x position of the mouse. | |
| y | This is the y position of the mouse. | |
| Remarks | For more information about using this event in your application, please see the Microsoft Access Help. | |
MultiLine Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets a value indicating if the control supports more than one line of text. | ||
| Setting | Setting | Description | VBA |
| Yes | The control supports multiple lines of text. | True | |
| No | The control only supports one line of text. | False | |
| Remarks | This property can only be set at design time. Setting this property to false will truncate any data that does not fit on the first line. | ||
Name Property
| Applies To | Font |
| Description | Returns or sets the font name of the font. |
| Setting | Accepts and returns string values. |
ObjectVerbFlags Property
| Applies To | OLEObject | |
| Description | Returns the menu flags of the object. | |
| Setting | Description | VBA |
| The menu item is checked. | rtfOLEFlagChecked | |
| The menu item is disabled. | rtfOLEFlagDisabled | |
| The menu item is enabled. | rtfOLEFlagEnabled | |
| The menu item is grayed. | rtfOLEFlagGrayed | |
| The menu item is a separator. | rtfOLEFlagSeparator | |
| Remarks | You must call FetchVerbs before referring to this property. | |
ObjectVerbs Property
| Applies To | OLEObject | |
| Description | Returns the verbs of the object. | |
| Setting | Description | VBA |
| Sets the verb to the default. | rtfOLEPrimary | |
| Opens the object. | rtfOLEShow | |
| Opens the object in a separate window. | rtfOLEOpen | |
| Hides the application that created the object. | rtfOLEHide | |
| Activates the object. | rtfOLEUIActivate | |
| In Place activates the object. | rtfOLEInPlaceActivate | |
| Causes the object to disregard undo information. | rtfOLEDiscardUndoState | |
| Remarks | You must call FetchVerbs before referring to this property. | |
ObjectVerbsCount Property
| Applies To | OLEObject |
| Description | Returns the number of verbs for the object. |
| Setting | Returns integer values. |
| Remarks | You must call FetchVerbs before referring to this property. |
OLEObject Property
| Applies To | OLEObjects | |
| Description | Returns an individual OLE Object. | |
| Setting | Returns an object. | |
| Properties | Name | Description |
| Class | This returns the class of the object. | |
| DisplayType | This returns the display type of the object. | |
| Index | This returns the index of the object. | |
| ObjectVerbFlags | This returns the verb flags of the object. | |
| ObjectVerbs | This returns the verbs of the object. | |
| ObjectVerbsCount | This returns the verb count of the object. | |
| Methods | Name | Description |
| DoVerb | This invokes a verb of the object. | |
| FetchVerbs | This retrieves the verbs of the object. | |
| Remarks | This property is an object containing properties and methods of its own. Refer to the properties of the object by using the VBA settings listed (e.g. OLEObject.Class). | |
OLEObjects Property
| Applies To | Total Access Memo | |
| Description | Returns a collection of OLEObject objects. | |
| Setting | Returns a collection. | |
| Remarks | Each OLE object in the control is represented in the OLEObjects collection. You can add objects to the control by calling the Add or Insert method, or by dragging an object into the control. This property is an object containing properties and methods of its own. Refer to the properties of the object using the VBA settings listed (e.g. OLEObjects.Add). To refer to a specific OLEObject, use a zero-based index as a parameter to this property. For example, to retrieve the class name of the first object in the collection, use the following syntax: String = tamDemo.OLEObjects(0.)Class |
|
| Properties | Name | Description |
| Count | The count of the OLE objects in the collection. | |
| Item | A specific item in the collection. | |
| Methods | Name | Description |
| Add | Adds an object to the collection. | |
| Clear | Clears all objects from the collection. | |
| InsertObject | Invokes the insert object dialog. | |
| Remove | Removes an object from the collection. | |
OpenEditor Method
| Applies To | Total Access Memo |
| Description | Opens the editor. |
| Syntax | fmsmemo.OpenEditor |
| Remarks | This method opens the editor even if the EditorEnabled property is set to False. The EditorOpen event is not fired if method is used to open the editor. |
Refresh Method
| Applies To | Total Access Memo |
| Description | Forces the control to refresh itself. |
| Syntax | fmsmemo.Refresh |
| Remarks | This method is useful if you need to force the control to repaint. |
Remove Method
| Applies To | OLEObjects | |
| Description | Removes a specified object form the control. | |
| Syntax | fmsmemo.OLEObjects.Remove(Item) | |
| Parameter | Description | |
| Item | This specifies the index of the object to remove. | |
RichEditVer Property
| Applies To | Total Access Memo |
| Description | Returns the version of RichEdit. |
| Setting | Returns long values. |
| Remarks | This property returns either 2 or 3. For more information on RichEdit, please see the Microsoft documentation. |
RightMargin Property
| Applies To | Total Access Memo |
| Description | Returns or sets the right margin of text. |
| Setting | Accepts and returns long values. |
| Remarks | Setting this to zero is the same as setting the right margin to the width of the control. |
SaveFile Method
| Applies To | Total Access Memo | |
| Description | Saves the text in the control to a file. | |
| Syntax | fmsmemo.SaveFile(bstrFileName, [vFileType]) | |
| Part | Description | |
| bstrFileName | This is the name of the file to load into the control. | |
| vFileType | This is the type of the file to load. This parameter is optional; if it is not specified, the control attempts to detect the file type. | |
| Description | VBA | |
| The file is saved as RTF. | rtfRTF | |
| The file is saved as text. | rtfText | |
ScrollBars Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets the style of the scroll bars. | ||
| Setting | Setting | Description | VBA |
| rtfNone | No scrollbars are displayed. | rtfNone | |
| rtfHorizontal | A horizontal scrollbar is displayed. | rtfHorizontal | |
| rtfVertical | A vertical scrollbar is displayed. | rtfVertical | |
| rtfBoth | Both scroll bars are displayed. | rtfBoth | |
| Remarks | This property can only be set at design time. | ||
SelAlignment Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the paragraph alignment of the current selection. | |
| Setting | Description | VBA |
| The current selection spans more than one paragraph with different alignments. | Null | |
| The paragraph is left aligned. | rtfLeft | |
| The paragraph is right aligned. | rtfRight | |
| The paragraph is center aligned. | rtfCenter | |
| The paragraph is fully justified. | rtfJustify | |
SelBold Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the bold style of the current selection. | |
| Setting | Description | VBA |
| The selection spans multiple characters with a mix of styles. | Null | |
| The selection is bold. | True | |
| The selection is not bold. | False | |
SelBullet Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the bullet style of the current selection. | |
| Setting | Description | VBA |
| The selection spans multiple characters with a mix of the font style. | Null | |
| The selection is bulleted. | True | |
| The selection is not bulleted. | False | |
SelChange Event
| Applies To | Total Access Memo |
| Description | Occurs when the selection changes. |
| Syntax | Sub fmsmemo_SelChange() |
SelCharOffset Property
| Applies To | Total Access Memo |
| Description | Returns or sets the offset, from the baseline, of the currently selected text. |
| Setting | Accepts and returns long values. |
| Remarks | The offset is the location of the bottom of the text. The baseline is the standard location of the bottom of the text. If this property returns null, it indicates that the selection spans multiple characters that have a mix of offsets. |
SelColor Property
| Applies To | Total Access Memo |
| Description | Returns or sets the foreground color of the current selection. |
| Setting | Accepts and returns long values. |
| Remarks | If this property returns null, it indicates that the selection spans multiple characters that have a mix of colors. |
SelectionBar Property
| Applies To | Total Access Memo | ||
| Description | Returns or sets a value indicating if a selection bar is displayed in the control. | ||
| Setting | Setting | Description | VBA |
| Yes | A selection bar is displayed. | True | |
| No | No selection bar is displayed. | False | |
SelFontCharSet Property
| Applies To | Font | |
| Description | Returns or sets the character set of the current selection’s font. | |
| Setting | Description | Description |
| Standard Windows characters. | 0 | |
| The symbol character set, including Wingdings and other symbol fonts. | 2 | |
| A character set unique to the Japanese version of Windows. | 128 | |
| Extended characters normally displayed by DOS applications. | 255 | |
SelFontName Property
| Applies To | Total Access Memo |
| Description | Returns or sets the font name of the current selection. |
| Setting | Accepts and returns string values. |
| Remarks | If this property returns null, it indicates that the selection spans multiple characters that have a mix of fonts. Please note that if you are using Wingdings, or another symbol character set, you must also set SelFontCharSet to 2. |
SelFontSize Property
| Applies To | Total Access Memo |
| Description | Returns or sets the font size of the current selection. |
| Setting | Accepts and returns integer values. |
| Remarks | If this property returns null, it indicates that the selection spans multiple characters that have a mix of sizes. |
SelHangingIndent Property
| Applies To | Total Access Memo |
| Description | Returns or sets the hanging indent of the current selection. |
| Setting | Accepts and returns long values. |
| Remarks | This property specifies the distance, in twips, between the left edge of the first line of text in the selected paragraph(s) (as specified by the SelIndent property) and the left edge of subsequent lines of text in the same paragraph(s). If this property returns null, it indicates that the selection spans multiple paragraphs that have a mix of margin settings. |
SelHyperlink Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the hyperlink style of the current selection. | |
| Setting | Description | VBA |
| The selection spans multiple characters with a mix of the style. | Null | |
| The selection is a hyperlink. | True | |
| The selection is not a hyperlink. | False | |
SelIndent Property
| Applies To | Total Access Memo |
| Description | Returns or sets the indent of the current selection. |
| Setting | Accepts and returns long values. |
| Remarks | This property specifies the distance, in twips, between the left edge of the control and the left edge of the selected text. If this property returns null, it indicates that the selection spans multiple paragraphs that have a mix of margin settings. |
SelItalic Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the italic style of the current selection. | |
| Setting | Description | VBA |
| The selection spans multiple characters with a mix of font style. | Null | |
| The selection is italicized. | True | |
| The selection is not italicized. | False | |
SelLength Property
| Applies To | Total Access Memo |
| Description | Returns or sets the length of the current selection. |
| Setting | Accepts and returns long values. |
SelPrint Method
| Applies To | Total Access Memo | |
| Description | Prints the current text selection. | |
| Syntax | fmsmemo.SelPrint(hdc) | |
| Part | Description | |
| hdc | This is a handle to a device context to print into. | |
| Remarks | If SelLength is zero, all text in the control is printed. | |
SelRightIndent Property
| Applies To | Total Access Memo |
| Description | Returns or sets the right indent of the current selection. |
| Setting | Accepts and returns long values. |
| Remarks | If this property is set to zero, the paragraph wraps to the right margin, otherwise, this property specifies the distance, in twips, between the right edge of the control and the right edge of the selected text. If this property returns null, it indicates that the selection spans multiple paragraphs that have a mix of margin settings. |
SelStart Property
| Applies To | Total Access Memo |
| Description | Returns or sets the starting character position of the current selection. |
| Setting | Accepts and returns integer values. |
SelStrikeThru Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the StrikeThru style of the current selection. | |
| Setting | Description | VBA |
| The selection spans multiple characters with a mix of the font style. | Null | |
| The selection has the StrikeThru style. | True | |
| The selection does not have the StrikeThru style. | False | |
SelTabCount Property
| Applies To | Total Access Memo |
| Description | Returns or sets the number of tab stops set in the current selection. |
| Setting | Accepts and returns integer values. |
| Remarks | This property returns the tab stops set in the selection, not the number of tabs in the selection. |
SelTabs Property
| Applies To | Total Access Memo |
| Description | Returns or sets the tab position of the specified tab. |
| Setting | Accepts and returns long values. |
| Remarks | This is a parameterized property, starting with a zero-based index. The tab positions are specified in twips. |
SelText Property
| Applies To | Total Access Memo |
| Description | Returns or sets the text of the current selection. |
| Setting | Accepts and returns string values. |
| Remarks | Setting this property replaces the current selection with the specified text. If no text is selected, the specified text is inserted in the current position. |
SelUnderline Property
| Applies To | Total Access Memo | |
| Description | Returns or sets the underline style of the current selection. | |
| Setting | Description | VBA |
| The selection spans multiple characters with a mix of the font style. | Null | |
| The selection is underlined. | True | |
| The selection is not underlined. | False | |
SelValue Property
| Applies To | Total Access Memo |
| Description | Returns or sets the text, in RTF format, for the current selection. |
| Setting | Accepts and returns strings. |
StrikeThrough Property
| Applies To | Font | |
| Description | Returns or sets the StrikeThrough style of the font. | |
| Setting | Description | VBA |
| The font has the StrikeThrough style. | True | |
| The font does not have the StrikeThrough style. | False | |
Text Property
| Applies To | Total Access Memo |
| Description | Returns or sets the text value of the control. |
| Setting | Accepts and returns strings. |
| Remarks | Setting this property destroys all formatting in the Total Access Memo control. The SelStart and SelText properties can be used to insert text into the control while preserving formatting. |
TextDocument Property
| Applies To | Total Access Memo |
| Description | Returns the text document object from the control (see Microsoft's About Text Object Model for more information). |
| Setting | Returns an object. |
| Remarks | This property returns the TextDocument object, which is an object supplied by Microsoft. By using this object, you can add additional RTF functionality programmatically. For more information on using this object model, see the hyperlink above, or the sample database included with Total Access Memo. NOTE: This property exposes the entire Microsoft Rich Text Object Model. FMS does not provide technical support for using the TextDocument property. |
Underline Property
| Applies To | Font | |
| Description | Returns or sets the underline style of the font. | |
| Setting | Description | VBA |
| The selection spans multiple characters with a mix of the font style. | Null | |
| The selection is underlined. | True | |
| The selection is not underlined. | False | |
Value Property
| Applies To | Total Access Memo |
| Description | Returns or sets the text, in RTF format, of the control. |
| Setting | Accepts and returns strings. |
| Remarks | This is the default and databound property of this control. |
Weight Property
| Applies To | Font |
| Description | Returns or set the weight of the font. |
| Setting | Returns integer values. |
| Remarks | The weight of a font determines the thickness of the characters. Weight values usually range from 0 to 1000, with 700 representing bold. Please note that this property is not available in Access’s property pages. |
Microsoft Access 64-bit Version is Shipping!
Supports 64 and 32-bit versions of Microsoft Access 2010, 2013, 2016, 2019, 2021, Office 365,
and Access 2007, 2003, 2002, and 2000!
Reviews
Best ActiveX Control
"Total Access Memo makes all the difference in my Access apps! Only Memo gives me fonts, colors, images and all the formatting tools I need. It's great!"
B. Simmons, Ciena, Linthicum, MD
Memo Info
Additional Info
