Hi,

I have created a form with large merged cells where people can put free type in. I need the text to stay inside the cell and be visible when printing. This is fine using wrap text until the user types more than the box can display - then the extra type is not visible when printing.

Is there anyway of limiting the amount of text that can go in to the cell before you press return (as required by Data Validation method), i.e could it just stop when 200 characters are reached -with a warning tone or message

Thanks and regards