Office 2007 Ultimate Use a validation rule instead
Reader Stefan Masic provides today's Power Tip. When you want to require users to enter a value in a field, Office Professional, a common technique is to set the Required property for that field to Yes (for example, tabPerson.Name.Required = Yes). However, Office Standard, when the user is then adding records to the table and neglects to insert value in that field, Office 2007 Ultimate, the built-in error message that appears is not very helpful: "The field . cannot contain Null value because the Required property is set to True. Enter a value in this field." This error message is not appropriate for typical users, whether it's in English or any other language. Instead,Office 2010 Code, I use another simple approach when building table properties: Set Table.Field.Required = No Set Table.Field.Validation Rule = IS NOT NULL Set Table.Field.Validation Text = The value in field is required. Enter a value or select it from the list. In this way,Microsoft Office Home And Business 2010, you can provide more specific information and helpful hints about how to enter the correct data, rather than just a "required" message. Note: When converting an Access table into SQL Server we must consider this design and set this table property manually. Send your Power Tips to Mike & Chris at accpower@microsoft.com.
|
