joec56 Posted August 6, 2007 Share Posted August 6, 2007 Hi all, I have set up a field to validate its content through validation by calculation. The validation condition works except not quite the way I wanted it. What I want is upon completion of entry in this field and when tab or return/enter is pressed, the data would have already been validated. As it is now, it only validates after all the data are entered, or click on anywhere (even after the field to be validated has been entered) on the layout other than any field. I hope I am making myself clear. Any help will be much appreciated. Thanks in advance. Link to comment Share on other sites More sharing options...
Vaughan Posted August 6, 2007 Share Posted August 6, 2007 That's the way it works: fields are only validated after the data entry has finished, which is when the cursor is moved to another field, or when the record is committed. Link to comment Share on other sites More sharing options...
joec56 Posted August 6, 2007 Author Share Posted August 6, 2007 Thanks Vaughan, I set up Tab, Return and Enter as keys to go to next object. By right, after I have entered the data in a field, and upon pressing any of the keys (Tab, Return or Enter) above to go to the next field, it would have performed the validation for the field last entered, right? But in my case, this is not happening, the tab key or return/enter key will actually lead me to all subsequent fields without prompting validation message when wrong data was deliberately entered. However, if I move the mouse and click anywhere on the screen, the validation message will appear, even before entering the subsequent field. Am I missing something? Thanks Link to comment Share on other sites More sharing options...
comment Posted August 6, 2007 Share Posted August 6, 2007 Validation by calculation happens when the user attempts to commit the record (e.g. by clicking on the layout's background). It needs to be so, because a calculation may reference other fields. Link to comment Share on other sites More sharing options...
Vaughan Posted August 6, 2007 Share Posted August 6, 2007 Ah, OK. So the other validation ttpes -- not empty, by value list, etc -- work on field exit? Link to comment Share on other sites More sharing options...
comment Posted August 7, 2007 Share Posted August 7, 2007 Each type has its own rule. Link to comment Share on other sites More sharing options...
joec56 Posted August 7, 2007 Author Share Posted August 7, 2007 Thanks a lot guys. So, can you please point me to where I can read about these rules? Thanks Link to comment Share on other sites More sharing options...
comment Posted August 7, 2007 Share Posted August 7, 2007 Not really. Some of them are in the help. Some additional information can be found on FMI's site. But I am not sure either one of these sources is entirely correct. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6235 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now