Easy.? Should be...

[BLeslie88]

I have 40 combo boxes ....

Basically an array of controls... anyhow to the point...

I want max length of 20 characters... These controls are unbound. So setting char length in table can not be used.

Validation text / rule should provide my solution somehow. I have tried a few things, and searched forums and help...

I mean len() function on lost focus would work, but hell there has to be a simple application to one of these properties to avoid coding for all these controls... even though all I would have to do is call one procedure on each control on lost focus.

Help please....???

Bri...

 

[FoFa]

Can't you use an input mask to limit the number of characters?

 

[BLeslie88]

Good point but...

>L0L 0L0

is postal code....

I can't use L's because this forces entry to be 20 in length....

In telephone number ... 9's are not required and 0's are...

So if someone can kindly tell me what character place holder is used for non required letters, this would indeed be a solution.

 

[EagleMon]

The question mark (?) is used as a non required letter!

The Eagle has landed!!!

 

[BLeslie88]

Well...

Using ? in input mask doesn't help much on a combo box.

They want autofill on keypress. If I use mask. then it doesn't autofill...

Example.

S/P

with mask, after s keypress now I get nothing...

I tried <????????????????????

I mean, all I want is a len check in the validation line of a control.

Mask is not providing the solution.... I saw something referencing it in help, but no example or syntax.... So I presume that a easy solution exists.

Without vba, which I will just do if no one can give me the solution I wish for without exclamation marks treating me like I am dumb...

I have tested and search for this, so maybe I am chasing a ghost...

So if anyone has a VALIDATION RULE solution, forcing <= 20 character input, then please reply.

Otherwire, I will just create a function to validation this text on lost focus.

Thanks.... !

 

[BLeslie88]

Back again.... To this...

Validation rule accepts <=len(20) in the arguement. (which doesn't help)

Tried <=len("????????????????????")

doesn't work.

Tried <=len("ZZZZZZZZZZZZZZZZZZZZ")

doesn't work.

I am figuring since the form accepts len as an argument, there must be a way to restrict the entry to 20 length... no...???