If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Continuous Forms Question
No, it does not!
"BruceM via AccessMonster.com" u54429@uwe wrote in message news:a8017af66df00@uwe... So you're saying that in your most recent example if the user makes an entry of greater than 10 characters the code doesn't stop them? Anatoly Kurilin wrote: As a matter of fact, I limited the length of the entry as an example of any cancelled action. And I don't want to remove the entry - user has to see what he/she entered. All I want is to make the control to behave in a proper way - there mustn't be any way to bypass the command Cancel = True. It seems that if the length of the entry in the field is greater than 10 characters you want to cancel the entry. Why not just limit the field [quoted text clipped - 27 lines] http://www.esetnod32.ru/.ml __________ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru/.ml -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 __________ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru/.ml __________ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru/.ml |
#12
|
|||
|
|||
Continuous Forms Question
If you want to validate field values you should use the form's Before Update
event. If the user does not make an entry in a control, the Before Update event for that control will not run, and a required value will not be checked. However, the form's Before Update event checks for values in any fields you choose. If you are talking about a control's Before Update event, the code as you entered it Beep and Cancel will result in a beep only if the user has the sound turned on. Cancel will cancel the update, but will not do anything to the field value. However, it will not let you leave the control without updating IF you updated the value by typing into the control (rather than by code). I cannot find a way to bypass the Cancel = True, but I suggest you add a line of code: Debug.Print "Before Update test" or MsgBox "Before Update Test" in the control's Before Update event to be sure it is running. Anatoly Kurilin wrote: No, it does not! So you're saying that in your most recent example if the user makes an entry [quoted text clipped - 19 lines] http://www.esetnod32.ru/.ml __________ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru/.ml -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
|
Thread Tools | |
Display Modes | |
|
|