TextBox Members
Collapse the table of content
Expand the table of content

TextBox Members (Access)

Office 2013 and later

This object corresponds to a text box. Text boxes on a form or report display data from a record source.

This object corresponds to a text box. Text boxes on a form or report display data from a record source.

Name

Description

AfterUpdate

The AfterUpdate event occurs after changed data in a control or record is updated.

BeforeUpdate

The BeforeUpdate event occurs before changed data in a control or record is updated.

Change

The Change event occurs when the contents of the specified control changes.

Click

The Click event occurs when the user presses and then releases a mouse button over an object.

DblClick

The DblClick event occurs when the user presses and releases the left mouse button twice over an object within the double-click time limit of the system.

Dirty

The Dirty event occurs when the contents of the specified control changes.

Enter

The Enter event occurs before a control actually receives the focus from a control on the same form or report.

Exit

The Exit event occurs just before a control loses the focus to another control on the same form or report.

GotFocus

The GotFocus event occurs when the specified object receives the focus.

KeyDown

The KeyDown event occurs when the user presses a key while a form or control has the focus. This event also occurs if you send a keystroke to a form or control by using the SendKeys action in a macro or the SendKeys statement in Visual Basic.

KeyPress

The KeyPress event occurs when the user presses and releases a key or key combination that corresponds to an ANSI code while a form or control has the focus. This event also occurs if you send an ANSI keystroke to a form or control by using the SendKeys action in a macro or the SendKeys statement in Visual Basic.

KeyUp

The KeyUp event occurs when the user releases a key while a form or control has the focus. This event also occurs if you send a keystroke to a form or control by using the SendKeys action in a macro or the SendKeys statement in Visual Basic.

LostFocus

The LostFocus event occurs when the specified object loses the focus.

MouseDown

The MouseDown event occurs when the user presses a mouse button.

MouseMove

The MouseMove event occurs when the user moves the mouse.

MouseUp

The MouseUp event occurs when the user releases a mouse button.

Undo

Occurs when the user undoes a change.

Name

Description

Move

Moves the specified object to the coordinates specified by the argument values.

Requery

The Requery method updates the data underlying a specified control that's on the active form by requerying the source of data for the control.

SetFocus

The SetFocus method moves the focus to the specified form, the specified control on the active form, or the specified field on the active datasheet.

SizeToFit

You can use the SizeToFit method to size a control so it fits the text or image that it contains.

Undo

You can use the Undo method to reset a control or form when its value has been changed.

Name

Description

AddColon

Specifies whether a colon follows the text in labels for new controls. Read/write Boolean.

AfterUpdate

Returns or sets which macro, event procedure, or user-defined function runs when the AfterUpdate event occurs. Read/write String.

AllowAutoCorrect

You can use the AllowAutoCorrect property to specify whetherthe specified control will automatically correct entries made by the user. Read/write Boolean.

Application

You can use the Application property to access the active Microsoft Access Application object and its related properties. Read-only Application object.

AsianLineBreak

Returns or sets a Boolean indicating whether line breaks in text boxes follow rules governing East Asian languages. True to control line breaks based on East Asian language rules. Read/write.

AutoLabel

Specifies whether labels are automatically created and attached to new controls. Read/write Boolean.

AutoTab

You can use the AutoTab property to specify whether an automatic tab occurs when the last character permitted by a text box control's input mask is entered. An automatic tab moves the focus to the next control in the form's tab order. Read/write Boolean.

BackColor

Gets or sets the interior color of the specified object. Read/write Long.

BackShade

Gets or sets the shade applied to the theme color in the BackColor property of the specified object. Read/write Single.

BackStyle

You can use the BackStyle property to specify whether a control will be transparent. Read/write Byte.

BackThemeColorIndex

Gets or sets a value that represents a color in the applied color theme associated with the BackColor property of the specified object. Read/write Long.

BackTint

Gets or sets the tint that is applied to the theme color in the BackColor property of the specified object. Read/write Single.

BeforeUpdate

Returns or sets which macro, event procedure, or user-defined function runs when the BeforeUpdate event occurs. Read/write String.

BorderColor

You can use the BorderColor property to specify the color of a control's border. Read/write Long.

BorderShade

Gets or sets the shade that is applied to the theme color in the BorderColor property of the specified object. Read/write Single.

BorderStyle

Specifies how a control's border appears.Read/write Byte.

BorderThemeColorIndex

Gets or sets a value that represents a color in the applied color theme associated with the BorderColor property of the specified object. Read/write Long.

BorderTint

Gets or sets the tint that is applied to the theme color in the BorderColor property of the specified object. Read/write Single.

BorderWidth

You can use the BorderWidth property to specify the width of a control's border. Read/write Byte.

BottomMargin

Along with the LeftMargin, RightMargin, and TopMargin properties, specifies the location of information displayed within a text box control. Read/write Integer.

BottomPadding

Gets or sets the amount of space (in inches) between the text box and its bottom gridline. Read/write Integer.

CanGrow

Gets or sets whether the specified control automatically adjusts vertically to print or preview all the data the control contains. Read/write Boolean.

CanShrink

Gets or sets whether the specified control automatically adjusts vertically to print or preview all the data the section or control contains. Read/write Boolean.

ColumnHidden

You can use the ColumnHidden property to show or hide a specified column in Datasheet view. Read/write Boolean.

ColumnOrder

You can use the ColumnOrder property to specify the order of the columns in Datasheet view. Read/write Integer.

ColumnWidth

You can use the ColumnWidth property to specify the width of a column in Datasheet view. Read/write Integer.

Controls

Returns the Controls collection of a form, subform, report or section. Read-only Controls.

ControlSource

You can use the ControlSource property to specify what data appears in a control. You can display and edit data bound to a field in a table, query, or SQL statement. You can also display the result of an expression. Read/write String.

ControlTipText

You can use the ControlTipText property to specify the text that appears in a ScreenTip when you hold the mouse pointer over a control. Read/write String.

ControlType

You can use the ControlType property in Visual Basic to determine the type of a control on a form or report. Read/write Byte.

DecimalPlaces

You can use the DecimalPlaces property to specify the number of decimal places Microsoft Access uses to display numbers. Read/write Byte.

DefaultValue

Specifies a value that is automatically entered in a field when a new record is created. For example, in an Addresses table you can set the default value for the City field to New York. When users add a record to the table, they can either accept this value or enter the name of a different city. Read/write String.

DisplayAsHyperlink

Gets or sets an AcDisplayAsHyperlink constant that specifies whether to display the contents of the specified text box as a hyperlink. Read/write.

DisplayWhen

You can use the DisplayWhen property to specify which of a form's controls you want displayed on screen and in print. Read/write Byte.

Enabled

You can use the Enabled property to set or return the status of the conditional format in the FormatCondition object. Read/write Boolean.

EnterKeyBehavior

You can use the EnterKeyBehavior property to specify what happens when you press ENTER in a text box control in Form view or Datasheet view. Read/write Boolean.

EventProcPrefix

Gets or sets the prefix portion of an event procedure name. Read/write String.

FilterLookup

You can use the FilterLookup property to specify whether values appear in a bound text box control when using the Filter By Form or Server Filter By Form window. Read/write Byte.

FontBold

You can use the FontBold property to specify whether a font appears in a bold style in the following situations:

FontItalic

You can use the FontItalic property to specify whether text is italic in the following situations:

FontName

You can use the FontName property to specify the font for text in the following situations:

FontSize

You can use the FontSize property to specify the point size for text in the following situations:

FontUnderline

You can use the FontUnderline property to specify whether text is underlined in the following situations:

FontWeight

You can use the DatasheetFontWeight property to specify the line width of the font used to display and print characters for field names and data in Datasheet view. Read/write Integer.

ForeColor

You can use the ForeColor property to specify the color for text in a control. Read/write Long.

ForeShade

Gets or sets the shade that is applied to the theme color in the ForeColor property of the specified object. Read/write Single.

ForeThemeColorIndex

Gets or sets a value that represents a color in the applied color theme associated with the ForeColor property of the specified object. Read/write Long.

ForeTint

Gets or sets the tint that is applied to the theme color in the ForeColor property of the specified object. Read/write Single.

Format

You can use the Format property to customize the way numbers, dates, times, and text are displayed and printed. Read/write String.

FormatConditions

You can use the FormatConditions property to return a read-only reference to the FormatConditions collection and its related properties.

FuriganaControl

GridlineColor

Gets or sets the color of the gridline for the specified text box. Read/write Long.

GridlineShade

Gets or sets the shade applied to the theme color in the GridlineColor property of the specified object. Read/write Single.

GridlineStyleBottom

Gets or sets the bottom gridline style of the specified text box. Read/write Byte.

GridlineStyleLeft

Gets or sets the width of the bottom gridline for the specified text box. Read/write Byte.

GridlineStyleRight

Gets or sets the right gridline style of the specified text box. Read/write Byte.

GridlineStyleTop

Gets or sets the top gridline style of the specified text box. Read/write Byte.

GridlineThemeColorIndex

Gets or sets the theme color index that represents a color in the applied color theme associated with the GridlineColor property of the specified object. Read/write Long.

GridlineTint

Gets or sets the tint applied to the theme color in the GridlineColor property of the specified object. Read/write Single.

GridlineWidthBottom

Gets or sets the width of the bottom gridline for the specified text box. Read/write Byte.

GridlineWidthLeft

Gets or sets the width of the left gridline for the specified text box. Read/write Byte.

GridlineWidthRight

Gets or sets the width of the right gridline for the specified text box. Read/write Byte.

GridlineWidthTop

Gets or sets the width of the top gridline for the specified text box. Read/write Byte.

Height

Gets or sets the height of the specified object in twips. Read/write Integer.

HelpContextId

The HelpContextID property specifies the context ID of a topic in the custom Help file specified by the HelpFile property setting. Read/write Long.

HideDuplicates

You can use the HideDuplicates property to hide a control on a report when its value is the same as in the preceding record. Read/write Boolean.

HorizontalAnchor

Gets or sets an AcHorizontalAnchor constant that indicates how the text box is anchored horizontally within its layout. Read/write.

Hyperlink

You can use the Hyperlink property to return a reference to a Hyperlink object. You can use the Hyperlink property to access the properties and methods of a control's hyperlink. Read-only.

IMEHold

Language-specific information You can use the IMEHold/Hold KanjiConversionMode property to show whether the Kanji Conversion Mode is maintained when the control loses the focus. Read/write Boolean.

IMEMode

IMESentenceMode

InputMask

You can use the InputMask property to make data entry easier and to control the values users can enter in a text boxcontrol. Read/write String.

InSelection

You can use the InSelection property to determine or specify whether a control on a form in Design view is selected. Read/write Boolean.

IsHyperlink

You can use the IsHyperlink property to specify or determine if the data contained in a text box is a hyperlink. Read/write Boolean.

IsVisible

You can use the IsVisible property in to determine whether a control on a report is visible. Read/write Boolean.

KeyboardLanguage

LabelAlign

The property specifies the text alignment within attached labels on new controls. Read/write Byte.

LabelX

The LabelX property (along with the LabelY property) specifies the placement of the label for a new control. Read/write Integer.

LabelY

The LabelY property (along with the LabelX property) specifies the placement of the label for a new control. Read/write Integer.

Layout

Returns the type of layout for the specified text box. Read-only AcLayoutType.

LayoutID

Returns the unique identifier for the layout that contains the specified text box. Read-only Long.

Left

You can use the Left property to specify an object's location on a form or report. Read/write Integer.

LeftMargin

Along with the TopMargin, RightMargin, and BottomMargin properties. specifies the location of information displayed within a text box control. Read/write Integer. .

LeftPadding

Gets or sets the amount of space (in inches) between the text box and its left gridline. Read/write Integer.

LineSpacing

You can use the LineSpacing property to specify or determine the location of information displayed within a label or text box control. Read/write Integer.

Locked

The Locked property specifies whether you can edit data in a control in Form view. Read/write Boolean.

Name

You can use the Name property to specify or determine the string expression that identifies the name of an object. Read/write String.

NumeralShapes

OldBorderStyle

You can use this property to set or returns the unedited value of the BorderStyle property for a form or control. This property is useful if you need to revert to an unedited or preferred border style. Read/write Byte.

OldValue

You can use the OldValue property to determine the unedited value of a bound control. Read-only Variant.

OnChange

Sets or returns the value of the On Change box in the Properties window of one of the objects in the Applies To list. Read/write String.

OnClick

Sets or returns the value of the On Click box in the Properties window. Read/write String.

OnDblClick

Sets or returns the value of the On Dbl Click box in the Properties window. Read/write String.

OnDirty

Sets or returns the value of the On Dirty box in the Properties window of a form or report. Read/write String.

OnEnter

Sets or returns the value of the On Enter box in the Properties window of specified object. Read/write String. .

OnExit

Sets or returns the value of the On Exit box in the Properties window of specified object. Read/write String. .

OnGotFocus

Sets or returns the value of the On Got Focus box in the Properties window of the specified object. Read/write String.

OnKeyDown

Sets or returns the value of the On Key Down box in the Properties window. Read/write String.

OnKeyPress

Sets or returns the value of the On Key Press box in the Properties window. Read/write String.

OnKeyUp

Sets or returns the value of the On Key Up box in the Properties window. Read/write String.

OnLostFocus

Sets or returns the value of the On Lost Focus box in the Properties window of the specified object. Read/write String.

OnMouseDown

Sets or returns the value of the On Mouse Down box in the Properties window. Read/write String.

OnMouseMove

Sets or returns the value of the On Mouse Move box in the Properties window. Read/write String.

OnMouseUp

Sets or returns the value of the On Mouse Up box in the Properties window. Read/write String.

OnUndo

Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the Undo event occurs. Read/write..

Parent

Returns the parent object for the specified object. Read-only.

PostalAddress

You can use the PostalAddress Property property to specify or determine the postal code and the Customer Barcode data corresponding to the address information displayed in a specified field/textbox. The PostalAddress Property wizard enables the setting of these properties. Read/write String.

Properties

Returns a reference to a control's Properties collection object. Read-only.

ReadingOrder

You can use the ReadingOrder property to specify or determine the reading order of words in text. Read/write Byte.

RightMargin

Along with the TopMargin, Left Margin, and BottomMargin properties, specifies the location of information displayed within text box control. Read/write Integer.

RightPadding

Gets or sets the amount of space (in inches) between the text box and its right gridline. Read/write Integer.

RunningSum

You can use the RunningSum property to calculate record-by-record or group-by-group totals in a report. Read/write Byte.

ScrollBarAlign

You can use the ScrollBarAlign to specify or determine the alignment of a vertical scroll bar. Read/write Byte.

ScrollBars

You can use the ScrollBars property to specify whether scroll bars appear on a text box control. Read/write Byte.

Section

You can identify these controls by the section of a form or report where the control appears. Read/write Integer.

SelLength

The SelLength property specifies or determines the number of characters selected in a text box. Read/write Integer.

SelStart

The SelStart property specifies or determines the starting point of the selected text or the position of the insertion point if no text is selected. Read/write Integer.

SelText

The SelText property returns a string containing the selected text. Read/write String.

ShortcutMenuBar

You can use the ShortcutMenuBar property to specify the shortcut menu that will appear when you right-click on the specified object. Read/write String.

ShowDatePicker

Gets or sets whether the date picker control is displayed for the specified text box. Read/write Integer.

SmartTags

Returns a SmartTags collection that represents the collection of smart tags that have been added to a control. .

SpecialEffect

You can use the SpecialEffect property to specify whether special formatting will apply to the specified object. Read/write Byte.

StatusBarText

You can use the StatusBarText property to specify the text that is displayed in the status bar when a control is selected. Read/write String.

TabIndex

You can use the TabIndex property to specify a control's place in the tab order on a form or report. Read/write Integer.

TabStop

You can use the TabStop property to specify whether you can use the TAB key to move the focus to a control. Read/write Boolean.

Tag

Stores extra information about a form, report, section, or control needed by a Microsoft Access application. Read/write String.

Text

You can use the Text property to set or return the text contained in a text box. Read/write String.

TextAlign

The TextAlign property specifies the text alignment in new controls. Read/write Byte.

TextFormat

Gets or sets whether rich text is displayed in the specified text box. Read/write AcTextFormat.

ThemeFontIndex

Gets or sets the font index that represents a font in the applied theme associated with the FontName property of the specified object. Read/write Long.

Top

You can use the Top property to specify an object's location on a form or report. Read/write Integer. .

TopMargin

Along with the LeftMargin, RightMargin, and BottomMargin properties, specifies the location of information displayed within a text box control. Read/write Integer.

TopPadding

Gets or sets the amount of space (in inches) between the text box and its top gridline. Read/write Integer.

ValidationRule

You can use the ValidationRule property to specify requirements for data entered into a record, field, or control. When data is entered that violates the ValidationRule setting, you can use the ValidationText property to specify the message to be displayed to the user. Read/write String.

ValidationText

Use the ValidationText property to specify a message to be displayed to the user when data is entered that violates a ValidationRule setting for a record, field, or control. Read/write String.

Value

Determines or specifies the text in the text box. Read/write Variant.

Vertical

You can use the Vertical property to set a form control for vertical display and editing or set a report control for vertical display and printing. Read/write Boolean.

VerticalAnchor

Gets or sets an AcVerticalAnchor constant that indicates how the specified text box is anchored vertically within its layout. Read/write.

Visible

Returns or sets whether the object is visible. Read/write Boolean.

Width

Gets or sets the width of the specified object in twips. Read/write Integer.

Show:
© 2016 Microsoft