View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
michelle michelle is offline
external usenet poster
 
Posts: 310
Default Setting Field Size in Excel 2003

I am trying to modify a form created by a co-worker. He has it set to type as
many characters in a field as a user wants but then gives a warning when you
hit enter letting you know that you have used more than the allowed number of
characters for that field.

Is there a way to set up each field to stop typing once the maximum number
of characters have been reached rather than having to go back and delete
characters once the typing is done?

Thanks for any assistance you may be able to provide on this subject!