Limiting characters

[chaseae]

Is there a way to limit the amount of characters that can be entered into a number field? I would like to create a separate 5-digit zip code and zip+4 fields and I want the cursor to automatically jump to the zip+4 field after the user enters the 5-digit zip code.

Thanks in advance for any help!!

[Korky]

You can easily limit the number of characters in a field in v5.5 by validating the field and selecting the appropriate option. In earlier versions use validation by calculation with the following:-

Length(Zip) <= 5

[Fitch]

It would be nice, but you can't make the cursor automatically jump to the zip+4 field, you have to tab.

One alternative would be to have a field that calculates the zip+4 after the fact. I.e., enter all 9 digits in one field, then have another field do the formatting:

Left(Zip, 5) & "-" & Right(Zip,4)

(Be sure to use TEXT fields for zips!)