A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Continuous Forms Question



 
 
Thread Tools Display Modes
  #11  
Old May 15th, 2010, 06:52 AM posted to microsoft.public.access.forms
Anatoly Kurilin
external usenet poster
 
Posts: 21
Default 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  
Old May 17th, 2010, 12:55 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.