Use a lookup table & set the field to limit the entries : ValidationRule Property 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. Note The ValidationRule and ValidationText properties don't apply to check box, option button, or toggle button controls when they are in an option group. They apply only to the option group itself. Remarks Enter an expression for the ValidationRule property setting and text for the ValidationText property setting. The maximum length for the ValidationRule property setting is 2048 characters. The maximum length for the ValidationText property setting is 255 characters. For controls, you can set the ValidationRule property to any valid expression. For field and record validation rules, the expression can't contain user-defined functions, domain aggregate or aggregate functions, the Eval function, or CurrentUser method, or references to forms, queries, or tables. In addition, field validation rules can't contain references to other fields. For records, expressions can include references to fields in that table. You can set the ValidationRule and ValidationText properties by using:
The Field Properties section of table Design view (for a field validation rule). The property sheet for a table by clicking Properties on the View menu in table Design view (for a record validation rule). The property sheet for a control on a form. A macro or Visual Basic. In Visual Basic, use a string expression to set these properties. For table fields and records, you can also set these properties in Visual Basic by using the DAO ValidationRule property. Microsoft Access automatically validates values based on a field's data type; for example, Microsoft Access doesn't allow text in a numeric field. You can set rules that are more specific by using the ValidationRule property. If you set the ValidationRule property but not the ValidationText property, Microsoft Access displays a standard error message when the validation rule is violated. If you set the ValidationText property, the text you enter is displayed as the error message. For example, when a record is added for a new employee, you can enter a ValidationRule property requiring that the value in the employee's StartDate field fall between the company's founding date and the current date. If the date entered isn't in this range, you can display the ValidationText property message: "Start date is incorrect." If you create a control by dragging a field from the field list, the field's validation rule remains in effect, although it isn't displayed in the control's ValidationRule property box in the property sheet. This is because a field's validation rule is inherited by a control bound to that field. Control, field, and record validation rules are applied as follows: Validation rules you set for fields and controls are applied when you edit the data and the focus leaves the field or control. Validation rules for records are applied when you move to another record. If you create validation rules for both a field and a control bound to the field, both validation rules are applied when you edit data and the focus leaves the control. The following table contains expression examples for the ValidationRule and ValidationText properties. --- On Mon, 5/11/09, toto_wow <[email protected]> wrote: From: toto_wow <[email protected]> Subject: [ms_access] data entry limitation To: [email protected] Date: Monday, May 11, 2009, 7:56 PM hi friends, i have problem to give limitation to entry data, for example the numeric code is 1 = man 2 = woman, so there no 3 and so on.. please advice. thank you toto [Non-text portions of this message have been removed]
