The form control that can accept numerical data input is the "text box". There are some basic controls in the form in Access. The text boxes are mainly used to enter or edit data and are bound to field data.
The operating environment of this tutorial: Windows 10 system, Dell G3 computer, Microsoft Office Access2019.
Commonly used controls in access forms - text boxes
The text box can be said to be the most commonly used control in the form, and the most commonly used one is binding. The text box from which the control comes, that is, the text box that displays the table/query fields.The text box is mainly used to enter or edit data and is bound to field data.
When the form itself has no record source, you can also arrange some unbound text boxes. For example, some friends need to edit records first and then add or update table data through the save button. This is how they do it.
As the most commonly used control in forms, the text box has very complete properties. Such as: format, mask, default value, input method, validity, multi-line, display, available, locked, etc., as well as many background colors, foreground colors (font colors), border settings, and many events.
Since text boxes are often used by everyone, they should be familiar with them. Here are just a few to talk about.
Can be expanded or reduced: This property can only be used when printing or previewing the form. Only the display of form sections and controls will be affected. When displayed in other views, it will not be affected.
When to display: Here you can set whether the form is displayed or when the form is printed. In fact, most of them have this property, but we don’t often print the form and rarely pay attention to it. .
Validity rules and validity text: Here you can set the rules for the value of this text box. For example: if you want to set this value to a positive value, then enter in the validity rule: >0, enter in validity text: Please enter a value greater than zero here. It should be noted again that validation rules can also reference other controls.
The help explains it in more detail. The excerpt is as follows:
When editing data and the focus leaves the field or control, the validity rules set by the field and control will be applied. .
When moving to other records, the record's validity rules will be applied.
If a field and a control bound to the field have validation rules created, both validation rules will be applied when the data is edited and the focus leaves the control.
Available and locked: If some fields of a form are not expected to be edited by users, they can be locked. In the case of locking, it can still get focus, but cannot be edited. If available is set to No, Then, it doesn't even have a chance to get focus. If both available and locked are negative, it will be grayed out.
Tab key index: Most friends probably don’t pay attention to this little thing. In fact, for a rigorous interface, it is indeed quite important. Its function is to respond to the focus transfer sequence when the keyboard operates the Tab key. In fact, the real settings are usually not set directly in the properties dialog box, but in the pop-up dialog box of "View" - "Tab Key Order" in the menu.
If you want the Tab key to ignore skipping of a control, you can set its tab stop property to No.
When you press the Tab key continuously, the cursor may jump to the next record, which may cause trouble for some friends' single form design. The solution is: loop the form The property is set to the current record.
The text box control can not only bind the displayed field value, but also display the value of the expression, that is: =..., click the small three-dot button to the right of the control source property to start the expression generator , you can edit your expression.
The text box control can be changed to: label, combo box, list box
After changing to a label, the binding will be automatically lost
Shortcut menu bar: If you have customized For shortcut menus, in this property you can select from the following boxes.
Control prompt text: The text content entered on this property will pop up a prompt when the mouse points to the text box and stays briefly in your form view.
For more knowledge about computer programming, please visit:Programming Video! !
The above is the detailed content of What is a form control that can accept numerical data input?. For more information, please follow other related articles on the PHP Chinese website!