Data required validation in form View

[mhifd009]

Access 2003 - I have set all records in a table to required, trying to add new record in table view gives relevent errors, but does not do this in form view - i need to ensure that all fields have data in them, form doesnt add record but doesnt give errors - please help if u can

[willakawill]

Access 2003 - I have set all records in a table to required, trying to add new record in table view gives relevent errors, but does not do this in form view - i need to ensure that all fields have data in them, form doesnt add record but doesnt give errors - please help if u can

When you are using databound controls in Access you have to do a little bit of coding to check the values in your controls. While it is fairly convenient for a beginner to have Access populate a form and handle new and deleted records, there are limits to what you can control. I never use data bound controls and there is quite a steep learning curve to get to that place. Up to you if you want to learn it. It won't happen in a forum though. You are going to have to get a book and work through some examples.

Good luck

[mhifd009]

When you are using databound controls in Access you have to do a little bit of coding to check the values in your controls. While it is fairly convenient for a beginner to have Access populate a form and handle new and deleted records, there are limits to what you can control. I never use data bound controls and there is quite a steep learning curve to get to that place. Up to you if you want to learn it. It won't happen in a forum though. You are going to have to get a book and work through some examples.

Good luck

Thanks for your feedback, whilst I am not an expert I do use the code builder section so I could use validation rules such as isnull, trim(field) = "" etc, is this what you mean, or do i unbound the controls and update/ add record to table on close.

[NeoPa]

Yes, IsNull() is a good one to use for this.
i think what Will's saying is that the Required property is handled automatically in Table layout, but a Form is something you 'superimpose' and is a higher level - not directly connected to the underlying table as a table grid is.