By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Problem with textbox in MS Access 2003

P: 4
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
Feb 15 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Subho

Although there is a facility to export a report to rtf file. It doesn't hold formating (no matter what you select) I'm afraid.

Mary
Feb 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.