Validation TextBox in Loop (Collection) ? A still no solved

Hi
Again, the same problem, a still no solved.
Already I have the procedure however I will want to use to all TextBoxes
in my app using to this collection.

Code:

---

Option Explicit

Private Sub Text1_KeyPress(Index As Integer, KeyAscii As Integer)


   

      Text1(Index).MaxLength = 5  '<<< it specifies the amount of signs


        If KeyAscii = 13 Then      '<<< exceptionally do it permit for Enter key
            SendKeys "{tab}"
            KeyAscii = 0
     
        ElseIf KeyAscii <> 8 Then  '<<< or for BackSpace key

          '<<< if is comma
          '<<< then block for next the comma and other non-numeric signs
 
            If InStr(1, Text1(Index), ",") And KeyAscii = 44 Then KeyAscii = 0
              If Not IsNumeric(Chr$(KeyAscii)) And KeyAscii <> 44 Then
                MsgBox "ONLY numbers", vbCritical + vbOKOnly, "Attention !"
                KeyAscii = 0
              End If
        End If

          '<<< however when first the sign it's comma then add sign an zero
 
          If Mid$(Text1(Index), 1, 1) = "," Then
            Text1(Index).Text = "0" & Text1(Index).Text
            Text1(Index).SelStart = Len(Text1(Index))
          End If

---

This code working fine but... for the array controls

Thanks in advance

BTW: how to protect before use of pasted value - I think there is no sense to prevent an pasting this. Rather necessary it will be a some the procedure to checking the values. How to make?

Hello, knock, knock - someone know?

To code against pasting, use the checkboxs Change Event.

Hi All

Please me help, it's urgent for me.
Look in my first post

Thanks

What exactly is the problem? Also plaese don't bump your threads.

Martin, it was a fair bump IMO...he waited at least 24 hours and he got no reply...I know there's nothing in the rules for here that says 24 hours, but at least the guy waited for an answer :-)

Tam, if you want to protect against pasted values (people using cut and paste to paste in a number getting around keypress) you would use the text1_change event and validate the text in that textbox to make sure it fits with the rules you require :-)

The rest of your problems I can't help with...I've got *NO* idea whatsoever what you need

Quote:

---

Originally Posted by smUX

Martin, it was a fair bump IMO...he waited at least 24 hours and he got no reply...I know there's nothing in the rules for here that says 24 hours, but at least the guy waited for an answer :-)....

---

Imagine the mess if everyone who "waited at least 24 hours" fought to keep their threads on page 1. Because of that we discourage bumping and we have banned people who repeatedly ignore requests not to bump.

Quote:

---

Originally Posted by MartinLiss

Imagine the mess if everyone who "waited at least 24 hours" fought to keep their threads on page 1. Because of that we discourage bumping and we have banned people who repeatedly ignore requests not to bump.

---

But if everyone who never got a reply bumped their thread, it would be the same as them copying and pasting the post and reposting it, which would be allowed. Now I understand if someone bumps their thread to keep it popular, they should be banned, nuked, flamed and many other things...but if the post was never popular in the first place and no-one responded...you see what I am saying? Couldn't it just be treated as if the person reposted it?

I'll not talk any more about this...disagree or not, you're one of the ones in charge here :-)

Quote:

---

Originally Posted by smUX

But if everyone who never got a reply bumped their thread, it would be the same as them copying and pasting the post and reposting it, which would be allowed. Now I understand if someone bumps their thread to keep it popular, they should be banned, nuked, flamed and many other things...but if the post was never popular in the first place and no-one responded...you see what I am saying? Couldn't it just be treated as if the person reposted it?

I'll not talk any more about this...disagree or not, you're one of the ones in charge here :-)

---

No, reposting is also discouraged and I'll be happy to discuss this further via PMs if you like.

Sorry Martin for confusion but I didn't want here to create new thread. I thought that so will be it better. I didn't want to be in forefront of threads but only wanted restore this theme. I made this a first once and...a last once, OK. I understand it. My mistake. So.. coming back to theme this.

This code does validation for all textbox's but ONLY on a one form. And I want so to make it in whole my app. I don't know it's possible? How to make?

My second question it’s like this:

How to protect before pasting values - however I think there is no sense to prevent an pasting this directly in textbox . Rather probably necessary it will be a some the procedure inside code to checking the values.
thanks in advance

To have that code work for textboxes on more than one form you should add a new Sub to a code module that takes a textbox and an index value as inputs and then call that sub from wherever you want to.

Better parhaps might be to download and compile my NumberBox ActiveX control (you'll find a link in my signature). That already does what you want.