Hi,
I am running a report in MS Access 2003, and it has some fields placed side by side. One of the fields is a textbox named "Title". In the property option of this textbox, the "Can grow" is set to Yes and the between this Title textbox and the next textbox, there is blank space of 2 characters.
Now after running the report for a particular record with long title it is showing correctly, but when I am exporting it to an RTF file, the formatting is getting distorted, because, it it trying to fit the title in one line as much as it can and then the next part of the title goes to the next line. But due to that, the field next to the "Title" field is getting shifted a lot and the report looks unformatted.
Then I increased the space between the title field and the next field in the report design by another character, and now when I imported the earlier record got fixed but got the same problem in another record. In this way, it is really impossible to shorten the title field and increase the spaces between the 2 fields.
Is there any way by which the width of the textbox will always remain constant to whatever value set by me and the text inside that will get wrapped, just like how it happens with a cell in Excel document.
Please suggest
Thanks,
Subho