![]() |
Stop text from stringing into next field when empty
When I have a "sentence" of text in a field and the field next to it is empty, the sentence text strings into it and you don't see a empty field. I know that I can change the width of the field that the sentence is in, but that won't work in this case because I need it small, so is there a way to stop the text from wandering into the next field? This is not a Merge issue, by the way, Merge is not checked. I can go into the empty field and hit the space button to make the field before it (with the sentence) think that its not empty, but that only works while you have it open, even if you save, the string comes back the next time you access the file. HELP!! Thanks, Lalla -- NothingButRomance |
Format | Cells | Alignment | Text Control | Wrap Text.
-- Vasant "NothingButRomance" om wrote in message on.com... When I have a "sentence" of text in a field and the field next to it is empty, the sentence text strings into it and you don't see a empty field. I know that I can change the width of the field that the sentence is in, but that won't work in this case because I need it small, so is there a way to stop the text from wandering into the next field? This is not a Merge issue, by the way, Merge is not checked. I can go into the empty field and hit the space button to make the field before it (with the sentence) think that its not empty, but that only works while you have it open, even if you save, the string comes back the next time you access the file. HELP!! Thanks, Lalla -- NothingButRomance |
Format | Cells | Alignment | Text Control | Wrap Text.
or you coudl also try the "Shrink to Fit" option under Text control -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
All times are GMT +1. The time now is 01:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com