Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms Coding > Checking Field ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 41484 of 43413
Post > Topic >>

Checking Field Length

by "DS" <bootybox@[EMAIL PROTECTED] > Aug 4, 2008 at 11:08 AM

I'm typing into an unbound textbox.
I want to limit the number of characters that can be entered.
As your typing the letters in, if you go over a certain number, lets say 5
I 
want a msgbox (that Imade to pop up)
I tried this on the after update event but it doesn't seem to fire until 
after one leaves the field.  I need it to check in live time.  Any help is

appreciated.
Thanks
DS

Dim SZ As Long
SZ = Nz(Len(Me.Text0), 0)
If SZ > 5 Then
    DoCmd.OpenForm "frmMsgInfo"
    Forms!frmMsgInfo!TxtMsg = "5 Characters Only"
Else
End If
 




 8 Posts in Topic:
Checking Field Length
"DS" <bootyb  2008-08-04 11:08:37 
Re: Checking Field Length
"Allen Browne"   2008-08-04 23:18:47 
Re: Checking Field Length
"DS" <bootyb  2008-08-04 17:49:36 
Re: Checking Field Length
fredg <fgutkind@[EMAIL  2008-08-04 09:24:19 
Re: Checking Field Length
"DS" <bootyb  2008-08-04 17:54:46 
Re: Checking Field Length
"DS" <bootyb  2008-08-04 18:07:42 
Re: Checking Field Length
"DS" <bootyb  2008-08-05 10:37:42 
Re: Checking Field Length
"Linq Adams via Acce  2008-08-05 15:16:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 20:29:15 CST 2008.