Limit the number of lines in the text field

[milanm]

 I have an unusual request - to stop people from entering the 3rd line into the address text field (they should be able to enter one line or two lines but not the 3rd line and not the gap). However hard i try, i could not figure out how to do this.

This is an address field without town, county and postcode, which are in the separate fields. Users should be able to put unlimited number of characters in the first line, press enter/return, than put what ever number of characters in the second line and THAT SHOULD BE IT. They should be restricted from putting anything in the 3rd line of that particular text field.

Thanks

 

[Lee Smith]

It sounds like a structure problem. One field for each piece of information. i.e. Street Address, PO Box, City, State, Zip.

[bruceR]

I agree completely with Lee; your structure needs to change.

 

However, you could use an auto-enter calc like this to prevent entry of more than two lines.

A user might enter a third line; but it won't be accepted.

 

LeftValues( Self; 2)

[comment]

IMHO, you should use a script triggered by the Return keystroke. That way, users can be prevented from entering the third line, instead of being surprised (and annoyed) by seeing their entry disappear.

[milanm]

Yep, it works just fine,

thank you so much for your help guys