To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92322
------- Additional comments from [EMAIL PROTECTED] Fri Sep 19 10:33:59 +0000 2008 ------- There now is a property "Input required" for all form controls which also support the "Data field" property. FYI, this is the feature mail I'll write when the CWS goes to QA: All form controls which can be bound to a database column (i.e. have the "Data field" property) now have a new property called "Input required". Description ========= This property controls whether or not the input of this field is checked against being empty (NULL). It is evaluated for controls which are bound to a database field which is defined as required (i.e. which is not allowed to contain the special NULL value), immediately before the current record of the form is to be written into the database. If the property is set to "Yes", and the field contains no input when the current record is to be written to the database, then an error message will be shown to the user, and the respective control will be focused afterwards. Note that this is the known behaviour so far - the property defaults to "Yes" so that newly created controls behave as they would do in previous OOo versions. If the property is set to "No", and the field contains no input when the current record is to be written to the database, then this is ignored. It's up to the underlying database to either reject the update, or fill the respective column with a server-side default value. Functional Constraints ================= If the "Form data input checks for required fields" option in the advanced settings of the database document (Edit / Database / Advanced Settings ...) is *not* checked, then the "Input required" property for all controls in all forms in this database document does not have any effect, since the document-wide setting overrules the per-control settings. UI == In the property browser, the "Input required" is located immediately below the "Empty string is NULL" property, if it is present, otherwise immediately below the "Data field" property. If the "Data field" is not set (i.e. empty), then "Input required" is disabled, since it would be evaluated for bound controls only, anyway. If the "Empty string is NULL" is set to "No", then "Input required" is also disabled, since "Empty string is NULL" being "no" implies that when the user does not enter any value in the control, then an empty string, instead of the dedicated value NULL, is written, so there's always a non-NULL value no matter the user's action. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]