Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create fields in a form with a fixed length
Is it possible to create fields in a form with a fixed length? I tried using
Data - Validation. This does not work well because the user does not know the length has been exceeded until exiting the field. For example, I would like to set a field to a length of 20 characters and prevent the user from entering any data past the 20th character. I can create borders for the fields but Excel allows the users to keep typing, and they keep typing. Thanks |
#2
|
|||
|
|||
Create fields in a form with a fixed length
Type F1 - Type "Prevent invalid data entry in a worksheet"
"sgeels" wrote: Is it possible to create fields in a form with a fixed length? I tried using Data - Validation. This does not work well because the user does not know the length has been exceeded until exiting the field. For example, I would like to set a field to a length of 20 characters and prevent the user from entering any data past the 20th character. I can create borders for the fields but Excel allows the users to keep typing, and they keep typing. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting from Excel to a Fixed Length Flat File | Excel Worksheet Functions | |||
Export file to CSV delimited with fixed field length | Excel Discussion (Misc queries) | |||
Concantenate Text with numbers with fixed form | Excel Worksheet Functions | |||
How do I export an excel file as fixed length records | Excel Discussion (Misc queries) | |||
Save data in a worksheet in fixed length fields... | Excel Discussion (Misc queries) |