i have a question about validating. i searched the forums and found this sample and wondered if you could help me take it a step further. What happens if a user was in this sample app and then went to excel and copied a range of cells. for example. go to excel or another grid and in column one and two and row one and two put in 99999 in each cell. so thats four cells with the value 9999 in each one. then try and copy and paste the four cells into this sample app in its colum 1 and 2 and row 1 and 2 by selecting it as a range. when u do and then click off the fields it doesnt give u the validate error about the fields are not between 0 and 100 that it does when u enter the 99999 in a single cell. How can i catch that??? What i would really like it do is if the user enters what i said above and pasted them in, i''d like it instead of and error message for 4 cells(which it isnt doing at all now), i''d like it to come up with one error message and set all the cells they copied to in a range to the max validate value. I will attach the sample again that i downloaded in case it doesnt attach it here or u dont have it
>> Clay,
>>
>> I know about Direct-Trac but I didn''t think my question needed to go to that level and I _am_ hoping for interaction from the community on answering my question. My concern was that the thread on which I originally posted my question vanished.
>>
>> I already know about setting NumberRequired to true or false (your attached sample wasn''t), what I''m asking is about the use of the ValidateValueInfo class. The thread on which I originally posted my question showed us how to use it, but it basically just show another way of creating NumberRequired. I''m looking for some help on using the class and its members to roll a validation that requires numbers, but will also take a blank space.
>>
>> Or, should I just undo or escape the user''s entry if they are trying to make the cell blank?
>>
>> Thanks,
>> Tom
>
>Tom,
>
>Sorry about not adding the sample. here it is.
>
>Did you look in the Archives for your original post? There is a link to the Archives on the first forum page. Postings made before October 1, 2002, can be found there.
>
>I guess I am confused about what you are asking. I thought if you set numberrequired to false, you would get exactly the behavior you want, ie. the cell could accept either numbers or an empty string. The attached sample has this behavior, and all it does is set NumberRequired to false.
>
>How does this behavior differ from what you want?
>
>Regards,
>
>Clay
>
>
ValidateInfo_1941_8847.zip